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?
|