Code to tell user macros off - problem with saveas

Hi!!!

The code tells the user that is excel macros are off or the security is too high.
it hide all the sheets except the one that tell the user about the macros and when he activates the macros that page hides and all the others unhide.
The problem is when i'm trying to save the document (saveas) with a diferent name it gives me an error on

Please Login or Register  to view this content.

How to correct this code?


Thanks in advance

Please Login or Register  to view this content.

Originally Posted by royUK

Can you explain how thw macro works if macros aren't enabled or security is high? The code won't run, what should happen is the warning sheet should be visible.

Use Before_Close, not Before_Save, see

ForceUsersEnableMacros.zip

Hi RoyUK

Thanks for the help, "ForceUsersEnableMacros" it's easier...

The other code it's working fine as you can see in the example i send, the problem was when i try to save with another name .

Please Login or Register  to view this content.

in office 2007 was working wrong i tried

Please Login or Register  to view this content.

and worked fine.... I'm sorry about my English i'm from Portugal

Thanks again Roy