Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Security Level
Some users have their security level at High, and then don't know why the
file with macros doesn't work. I have seen suggestions on using SelfCert and dos and don'ts of changing registry. I like the suggestion of hiding all all sheets but one that display the warning that the macros won't work if macros are disabled, and maybe put instructions for them to change their security level. But I don't want the warning to display for users whose security level is Medium or Low. Is there a way to detect what security level the user has set so I can warm them if their settings automatically disable macros? Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Security Level
If security is high then macro's don't run. Use on_open event code to hide
the sheet that lets them know that the spreadsheet won't work with the high security setting. If security is other than high then the macro runs and the the sheet is never visible. This is the solution I have used. I do not know of any way of detecting security settings otherwise... HTH "kdw" wrote: Some users have their security level at High, and then don't know why the file with macros doesn't work. I have seen suggestions on using SelfCert and dos and don'ts of changing registry. I like the suggestion of hiding all all sheets but one that display the warning that the macros won't work if macros are disabled, and maybe put instructions for them to change their security level. But I don't want the warning to display for users whose security level is Medium or Low. Is there a way to detect what security level the user has set so I can warm them if their settings automatically disable macros? Thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Security Level
This would work. Thanks Jim.
"Jim Thomlinson" wrote: If security is high then macro's don't run. Use on_open event code to hide the sheet that lets them know that the spreadsheet won't work with the high security setting. If security is other than high then the macro runs and the the sheet is never visible. This is the solution I have used. I do not know of any way of detecting security settings otherwise... HTH "kdw" wrote: Some users have their security level at High, and then don't know why the file with macros doesn't work. I have seen suggestions on using SelfCert and dos and don'ts of changing registry. I like the suggestion of hiding all all sheets but one that display the warning that the macros won't work if macros are disabled, and maybe put instructions for them to change their security level. But I don't want the warning to display for users whose security level is Medium or Low. Is there a way to detect what security level the user has set so I can warm them if their settings automatically disable macros? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros/Security Level | Excel Discussion (Misc queries) | |||
Detecting Macro Security Level | Excel Programming | |||
Detecting Macro Security Level | Excel Programming | |||
Changing security level | Excel Programming | |||
Changing security level | Excel Programming |