Turn off Excel 2007 security warnings?

[NorthNone]

Is it possible to keep Excel 2007 from displaying security warnings about macros? We have some templates that people use on network drives with VBA code we want to run every time, but our users are getting sick of the security warnings.
We do not want to always let all Excel files run all macros all the time.
TIA
NorthNone

"Talent hits a target no one else can hit; Genius hits a target no one else can see." --- Arthur Schopenhauer

 

[kjv1611]

I think there is a way of setting up "secure" sources in a list. Though you might have to create some sort of certificate on the creation end. I remember seeing something about that option in all versions of Excel that I've ever looked at - at least 2000, XP, 2002, and 2003, and I think 2007, but I can't remember for sure.

--

"If to err is human, then I must be some kind of human!" -Me

 

[Welshbird]

You can create a certificate which certainly stops the message for those workbooks with a certificate.

(Can't remember how though)

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen