ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excell 2003 low macro secutiy changing is not staying in low (https://www.excelbanter.com/excel-discussion-misc-queries/71794-excell-2003-low-macro-secutiy-changing-not-staying-low.html)

djruby14

excell 2003 low macro secutiy changing is not staying in low
 
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

excell 2003 low macro secutiy changing is not staying in low
 
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

djruby14

excell 2003 low macro secutiy changing is not staying in low
 


"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

excell 2003 low macro secutiy changing is not staying in low
 
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


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com