Some users have their security level at High, and then don't know why the
file with macros doesn't work. I have seen suggestions on using SelfCert and
dos and don'ts of changing registry.

I like the suggestion of hiding all all sheets but one that display the
warning that the macros won't work if macros are disabled, and maybe put
instructions for them to change their security level.

But I don't want the warning to display for users whose security level is
Medium or Low. Is there a way to detect what security level the user has set
so I can warm them if their settings automatically disable macros?

Thanks in advance!

If security is high then macro's don't run. Use on_open event code to hide
the sheet that lets them know that the spreadsheet won't work with the high
security setting. If security is other than high then the macro runs and the
the sheet is never visible. This is the solution I have used. I do not know
of any way of detecting security settings otherwise...

HTH

"kdw" wrote:

> Some users have their security level at High, and then don't know why the
> file with macros doesn't work. I have seen suggestions on using SelfCert and
> dos and don'ts of changing registry.
>
> I like the suggestion of hiding all all sheets but one that display the
> warning that the macros won't work if macros are disabled, and maybe put
> instructions for them to change their security level.
>
> But I don't want the warning to display for users whose security level is
> Medium or Low. Is there a way to detect what security level the user has set
> so I can warm them if their settings automatically disable macros?
>
> Thanks in advance!
>
>

This would work. Thanks Jim.

"Jim Thomlinson" wrote:

> If security is high then macro's don't run. Use on_open event code to hide
> the sheet that lets them know that the spreadsheet won't work with the high
> security setting. If security is other than high then the macro runs and the
> the sheet is never visible. This is the solution I have used. I do not know
> of any way of detecting security settings otherwise...
>
> HTH
>
> "kdw" wrote:
>
> > Some users have their security level at High, and then don't know why the
> > file with macros doesn't work. I have seen suggestions on using SelfCert and
> > dos and don'ts of changing registry.
> >
> > I like the suggestion of hiding all all sheets but one that display the
> > warning that the macros won't work if macros are disabled, and maybe put
> > instructions for them to change their security level.
> >
> > But I don't want the warning to display for users whose security level is
> > Medium or Low. Is there a way to detect what security level the user has set
> > so I can warm them if their settings automatically disable macros?
> >
> > Thanks in advance!
> >
> >