Macro security in 2007

[cuartetto]

I have created an Excel SS using 2003. It contains macros. I have the macro
security set to 'medium' and when I open the SS I am asked to accept macros.
This same SS is being used on another computer which has Excel 2007. I have
not been able to figure out how to set the security in 2007 so that it will
ask permission to run a SS with macros. I have tryed checking each of the
four options in the macro security setup, the only one that will allow the SS
to open is the one with no security. Is it possible to have 2007 ask
permission to open a SS containing macros?

cuartetto

 

[Bob Umlas]

Office button/Excel Options/Trust Center, click button "Trust Center
settings", then Macro settings section. Here's where your choices are!

 

[jodleren]

Funny, that I just wrote about the same.

But the supplied link does not work.
Could you copy the text in stead?

WBR
Sonnich

 

[cuartetto]

I know how to get to the place to make the choices, but none of the choices
will cause me to have to allow this SS with macros to be opened. The idea is
I want it to function like 2002 did with the security set to 'medium'.

 

[Susan]

bob is right about where to find your choices, but you guys are right
in that there is no happy "medium" (LOL) in 2007. it's either open
completely with no notification of macros, or open saying macros have
been blocked ("Disable all macros with notification"). but when you
get that notification that they are blocked, you can unblock them each
time in each individual file, like "medium" security.
hope that helps

susan

 

[cuartetto]

Thanks

bob is right about where to find your choices, but you guys are right
in that there is no happy "medium" (LOL) in 2007. it's either open
completely with no notification of macros, or open saying macros have
been blocked ("Disable all macros with notification"). but when you
get that notification that they are blocked, you can unblock them each
time in each individual file, like "medium" security.
hope that helps

susan