Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
security
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
security
Not possible. The macro can't run, so it can't change the security
settings. -- Regards, Tom Ogilvy "tjh" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
security
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 "tjh" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security | Excel Discussion (Misc queries) | |||
Security | Excel Discussion (Misc queries) | |||
Security | Excel Discussion (Misc queries) | |||
security | Excel Discussion (Misc queries) | |||
Security | Excel Discussion (Misc queries) |