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

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

"cuartetto" wrote in message
...
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

Funny, that I just wrote about the same.

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

WBR
Sonnich

On Sep 3, 5:40*pm, "Bob Umlas" wrote:
Office button/Excel Options/Trust Center, click button "Trust Center
settings", then Macro settings section. Here's where your choices are!

"cuartetto" wrote in message

...

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

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'.

"Bob Umlas" wrote:

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

"cuartetto" wrote in message
...
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 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



On Sep 3, 11:17*am, cuartetto
wrote:
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'.



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

"cuartetto" wrote in message
...
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- Hide quoted text -

- Show quoted text -

Thanks

"Susan" wrote:

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



On Sep 3, 11:17 am, cuartetto
wrote:
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'.



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

"cuartetto" wrote in message
...
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- Hide quoted text -

- Show quoted text -