View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Hammett Rick Hammett is offline
external usenet poster
 
Posts: 1
Default Changing Macro Security settings does not work

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.

--
RH