Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Security
I have searched (pretty hard) to find a valid reason why excel might
reset macro security back to high (from medium) whenever it gets the urge! I have somebody who can be working with an excel document quite happily and then all of a sudden macros will stop running and they will get the "Macros are disabled because the security level is set to high....." dialog. Resetting the security back to medium, closing and reopening stops this but obviously it's not ideal. I have been informed that there are no group policies set up either. Anybody have any ideas? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Security
It is possible to change the Security level via VBA. Look for any instances
of this. Carefully review the use of SendKeys in your macros. -- Gary''s Student - gsnu200718 " wrote: I have searched (pretty hard) to find a valid reason why excel might reset macro security back to high (from medium) whenever it gets the urge! I have somebody who can be working with an excel document quite happily and then all of a sudden macros will stop running and they will get the "Macros are disabled because the security level is set to high....." dialog. Resetting the security back to medium, closing and reopening stops this but obviously it's not ideal. I have been informed that there are no group policies set up either. Anybody have any ideas? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Security
On 1 May, 13:56, Gary''s Student
wrote: It is possible to change the Security level via VBA. Look for any instances of this. Carefully review the use of SendKeys in your macros. -- Gary''s Student - gsnu200718 " wrote: I have searched (pretty hard) to find a valid reason why excel might reset macro security back to high (from medium) whenever it gets the urge! I have somebody who can be working with an excel document quite happily and then all of a sudden macros will stop running and they will get the "Macros are disabled because the security level is set to high....." dialog. Resetting the security back to medium, closing and reopening stops this but obviously it's not ideal. I have been informed that there are no group policies set up either. Anybody have any ideas? Thanks. Thanks, I wrote all of the macros, it definitely doesn't do that. Must be something else. It's not related to the spreadsheet as it behaves properly on other machines. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro Security stuck on Low | Excel Discussion (Misc queries) | |||
Macro security in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Security | Excel Discussion (Misc queries) | |||
Macro needed to set macro security in Excel to minimum | Excel Programming | |||
Excel XP XML macro security warning | Excel Programming |