Excel's macro security level settings are saved in the Registry.

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

On rightside window Level should be 2 for medium.

Perhaps you do not have sufficient rights to alter the Registry.

Someone with administrator rights may have to make the changes.


Gord Dibben MS Excel MVP


On Thu, 26 Oct 2006 09:28:01 -0700, DKS wrote:

Hi,

Currently I have Excel 2003 on XP operating system.

In the past, before migrating to this advanced version, I had macro security
set to MEDIUM whereby everytime I open a spreadsheet that contains macros the
Excel software prompts me if I would like to enable or disable the macros.

With the migration to Excel 2003, I cannot seem to re-establish this
setting. I tried via TOOLS - OPTIONS - SECURITY and I also tried via TOOLS -
MACRO - MACRO SECURITY.

But via both means, after setting the security to MEDIUM, i close .xls and
re-open it using a workbook containing macros and there is absolutely no
prompt. On re-verifying the option settings I discover that it has switched
back to LOW.

How can I permanently re-establish this setting?