security

[Guest]

Hello,
In an excel vba macro, is it possible to change the macro security settings
from high to low within the code? Allowing the macro to run when the user
opens the file even if their settings are set to high. Thank you

 

[Tom Ogilvy]

Not possible. The macro can't run, so it can't change the security
settings.

 

[Mike Fogleman]

You can add a sheet that has a big message in the middle of it like "You
must enable macros to use this workbook."
Now hide all your sheets but that one.
In the Workbook_Open Event, Unhide all your other sheets and Hide your
Message sheet.
In the Workbook_Close Event, Hide all your other sheets and Unhide your
Message sheet.
Now if someone tries to open the workbook with macros disabled, all they can
see is the Message sheet.

Mike F