Macro Securiy Level

  • Thread starter Thread starter Nader
  • Start date Start date
N

Nader

Hello,

I have a lot of Excel files with macro inside. Is it possible to set the
level of Macro Security to "Low" once and for all (Excel 2002 SP3) ?

Thanks in advance.

Regards,

Nader
 
Once you change this setting, it should stay changed.

Mine always did for xl2k (and for xl2002) and does for xl2003.

But since this setting is stored in the Windows Registry, maybe you don't have
permissions to change the registry (or that branch of the registry).

I'd talk to my IT folks and explain the problem. Maybe you'll get lucky and
they'll help you.
 
Hello Dave,

Thanks for the reply.

Could you tell me the path of the registry so I could try.

Thanks in advance.
 
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".
1 = low, 2 = medium, 3 = high.
 
Thanks a lot Dave!
Dave Peterson said:
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".
1 = low, 2 = medium, 3 = high.
Click to expand...
 
Back
Top