Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi, I set Excell 2003 macro security to low and works untill I close excell,
once I close and re-open it is going back to medium. how I can make it to stay in low. thanks manny |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is a setting that gets stored in the windows registry.
It sounds like you don't have permission to save it. I'd speak with the IT folks and ask why. djruby14 wrote: hi, I set Excell 2003 macro security to low and works untill I close excell, once I close and re-open it is going back to medium. how I can make it to stay in low. thanks manny -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "Dave Peterson" wrote: This is a setting that gets stored in the windows registry. It sounds like you don't have permission to save it. I'd speak with the IT folks and ask why. djruby14 wrote: hi, I set Excell 2003 macro security to low and works untill I close excell, once I close and re-open it is going back to medium. how I can make it to stay in low. thanks manny -- Dave Peterson hi could you please let me know which is the registry key? thanks manny |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Saved from a previous post:
The Excel security setting is saved in the registry under this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security This is for Excel 2003. Should be something similar for other versions. The item is "Level". You'd set this to 2 for medium === and just to add: 1 = low, 2 = medium, 3 = high. And 11.0 is xl2002. So for xl2k, you'd want 10.0 djruby14 wrote: "Dave Peterson" wrote: This is a setting that gets stored in the windows registry. It sounds like you don't have permission to save it. I'd speak with the IT folks and ask why. djruby14 wrote: hi, I set Excell 2003 macro security to low and works untill I close excell, once I close and re-open it is going back to medium. how I can make it to stay in low. thanks manny -- Dave Peterson hi could you please let me know which is the registry key? thanks manny -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing target sheet name wihtin a macro | Excel Discussion (Misc queries) | |||
2003 excell crashed after upgrade from microsoft. repair? | Excel Discussion (Misc queries) | |||
excell 2003 will not open previous version | Excel Discussion (Misc queries) | |||
how do I tell excell 2003 to print sheets back to front? | Excel Discussion (Misc queries) | |||
Macro not working with Excel 2003 | Excel Discussion (Misc queries) |