Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Application Security Settings
If someone has their security setting put to High is it possible to
either change their setting to Medium programmatically, or get a message box to pop up and tell them that they need to change their setting to Medium ? (I realise that none of the above is propbably possible as the security setting will be well protected.....but thought I'd ask anyhow, as a lot of people know nothing about Excel and blame my code when a program doesn't work - when it is simply that they have their settings too high) Any help appreciated Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Application Security Settings
You are correct in that you can not read or write to the security settings.
But you can use teh fact that if their security is set to high then no macro's will run. Create your spreadsheet using the on open and on close events. In the on close event hide all but one sheet that tells them that their security is set incorrectly. In the on open add code to unhide all of the sheets and hide the security instruction page. This way if their security is set to high then the only thing they will see is your instruction page telling them to change the security. Otherwise the spreadsheet will function as normal... -- HTH... Jim Thomlinson "WhytheQ" wrote: If someone has their security setting put to High is it possible to either change their setting to Medium programmatically, or get a message box to pop up and tell them that they need to change their setting to Medium ? (I realise that none of the above is propbably possible as the security setting will be well protected.....but thought I'd ask anyhow, as a lot of people know nothing about Excel and blame my code when a program doesn't work - when it is simply that they have their settings too high) Any help appreciated Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Application Security Settings
if in xl2002 and later, a high security setting disables macros for
uncertified workbooks. Once the macros are disabled, there is no way for you to tell the user anything or attempt to change anything. The usual recommendation is to put macros in your workbook that will hide all sheets except a message sheet that has a big message saying if you see this message, you need to set security to medium and close and reopen the workbook. Then if the workbook opens with macros enabled, your code would restore it to a working state and return it to the "protected" state upon closing. -- Regards, Tom Ogilvy "WhytheQ" wrote: If someone has their security setting put to High is it possible to either change their setting to Medium programmatically, or get a message box to pop up and tell them that they need to change their setting to Medium ? (I realise that none of the above is propbably possible as the security setting will be well protected.....but thought I'd ask anyhow, as a lot of people know nothing about Excel and blame my code when a program doesn't work - when it is simply that they have their settings too high) Any help appreciated Jason |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Application Security Settings
thanks folks!
good advice. Jase Tom Ogilvy wrote: if in xl2002 and later, a high security setting disables macros for uncertified workbooks. Once the macros are disabled, there is no way for you to tell the user anything or attempt to change anything. The usual recommendation is to put macros in your workbook that will hide all sheets except a message sheet that has a big message saying if you see this message, you need to set security to medium and close and reopen the workbook. Then if the workbook opens with macros enabled, your code would restore it to a working state and return it to the "protected" state upon closing. -- Regards, Tom Ogilvy "WhytheQ" wrote: If someone has their security setting put to High is it possible to either change their setting to Medium programmatically, or get a message box to pop up and tell them that they need to change their setting to Medium ? (I realise that none of the above is propbably possible as the security setting will be well protected.....but thought I'd ask anyhow, as a lot of people know nothing about Excel and blame my code when a program doesn't work - when it is simply that they have their settings too high) Any help appreciated Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security Settings | Excel Worksheet Functions | |||
Security Settings | Setting up and Configuration of Excel | |||
macro security settings excel change back to low | Excel Discussion (Misc queries) | |||
Use VBA to change security settings | Excel Programming | |||
Macro security settings | Excel Programming |