Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Security Level on Spreadsheet open
2 questions,,
1. Is it possible to change the security level when a spreadsheet opens, for example I have an automatited spreadsheet that has code and when it runs I want it to just go ahead and run, but on occasion there are other spreadsheets I want to be asked about the code. Is there anything I can put in the command line for the spreadsheet to change the security level 2.. If not how can I manually stop code running if I open a spreadsheet Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Security Level on Spreadsheet open
What causes the code to run? If an event, then
Application.EnableEvents = False. If you have excel 2003 (and maybe xl2002), you can look at application.AutomationSecurity See the help for details. -- Regards, Tom Ogilvy "Nigel" wrote in message ... 2 questions,, 1. Is it possible to change the security level when a spreadsheet opens, for example I have an automatited spreadsheet that has code and when it runs I want it to just go ahead and run, but on occasion there are other spreadsheets I want to be asked about the code. Is there anything I can put in the command line for the spreadsheet to change the security level 2.. If not how can I manually stop code running if I open a spreadsheet Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro security level in excel will not change | Excel Discussion (Misc queries) | |||
It's posible to change security level from VBA? | Excel Programming | |||
Using VBA to change macro security level | Excel Programming | |||
Security Level wont change... | Excel Programming | |||
Macro to change security level | Excel Programming |