View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Determining if Macro Can Run

If it is set to high, then no macros run unless they are certified. If
certified, then you don't need a warning, so I assume you are not certifying
your workbook. Therefore, you will never know if security is set to high
because your macro will not run.

--
Regards,
Tom Ogilvy

"mikem" wrote in message
...
I'm distributing an Excel file with macros. I'd like to
open a dialog box telling users to change the security
option to allow macros to run, but only if their macro
security is set to "high." How do I determine the security
level when the fiel is opened?