excell 2003 low macro secutiy changing is not staying in low

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Dave Peterson said:
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.
Click to expand...
hi could you please let me know which is the registry key?
thanks
manny
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro security settings excel change back to low 3
Macro Security to "Low" 7
how can i hange the macro security lavel on ms2007 2
Setting Excel Macro Security to "low" permanently. 2
Macro not working properly when run automatically 9
Setting macro security level to "low" permanently? 8
Excel macro settings change back to low 1
Unable to modify the level of protection of macro 4

Back
Top