Changing Macro Security settings does not work

[Rick Hammett]

When I set macro security settings to "Very High" (Tools -> Options ->
Security -> Macro Security -> Very High) and then run the macro I recently
wrote (Tools -> Macros -> Macro -> Run), I get a message stating that "Macros
are disabled because security settings are set to very high", as one would
expect.

Likewise, when I set macro security settings to "High", I get a similar
message that says, "Macros are disabled because the security level is set to
high and a digitially signed Trusted Cirtificate is not attached to the
Macros. To run the macros, change the security level to a low setting (not
recommended), or request the macros be signed by the author using a
certificate issued by a cirtificate authority."

The problem is that when I set the macro security settings to Medium and
Low, I get the same message telling me that the macro security settings are
set to "High" and of course the macro does not run. When I return to Macro
Security settings, the radio buttons are active where I last left them (Low
or Medium), but the program does not recognize the change.

Please help.

 

[Jim Thomlinson]

Change the settings (to medium) and then shut down Excel and re-open it. That
should take care of the problem. (Go with Medium and not low. Low is kinda
dangerous.)