Macro Securiy Level

[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

 

[Dave Peterson]

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.

 

[Nader]

Hello Dave,

Thanks for the reply.

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

Thanks in advance.

 

[Dave Peterson]

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.

 

[Nader]

Thanks a lot Dave!

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.