excell 2003 low macro secutiy changing is not staying in low

[Guest]

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]

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.

 

[Guest]

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.

hi could you please let me know which is the registry key?
thanks
manny

 

[Dave Peterson]

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\Excel\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