Can't do it. If security is high the macros won't run. Catch 22. Here is the
workaround. Add a sheet telling the user that macro security must be medium
or low. Use an on_open macro that does nothing but hide this sheet
(xlVeryHidden). If security is high then they see the sheet because the macro
won't run. Otherwise they see just what they are supposed to see. And to
answer your next question, no you can not change the security setting using a
macro.
--
HTH...

Jim Thomlinson


"mwh1107" wrote:

I would like to show a dialogue box telling user that they do not have
macro's enabled and that the file they are attempting to open requires
macro's to work properly. I'd like this to show up even if they have set
Macro Security to high.