Default macro security level xl 2003

Topic

New Reply

How do I change the default macro security level for all users to Medium from high?

Thanks

Reply | Quote

Replies

Hello – Try this

Tools>Security

Will show the following …..

Then choose Security tab and Macro Security button

Will show the following …..

Tim

Reply | Quote

Thanks Tim, but that sets the macro security for one user.

I found it though. I looked in the registry under HKCU to see what changed when I set the macro security, and the applied it to HKLM. It worked. Now whoever logs onto the machine is prompted to run or not run macros.

Reply | Quote

Thanks Tim, but that sets the macro security for one user.

I found it though. I looked in the registry under HKCU to see what changed when I set the macro security, and the applied it to HKLM. It worked. Now whoever logs onto the machine is prompted to run or not run macros.

Cecil,

Ok, give! Which key?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thanks Tim, but that sets the macro security for one user.

I found it though. I looked in the registry under HKCU to see what changed when I set the macro security, and the applied it to HKLM. It worked. Now whoever logs onto the machine is prompted to run or not run macros.

Sorry ’bout that.

From HKCU to HKLM.

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice11.0ExcelSecurity]
“Level”=dword:00000002

Reply | Quote

Cecil,

Thanks for the key.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote