Detecting Macro Secutiry Settings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this is probably a Mute point question but I was wondering if there
was a way to detect if a user disables macros and the stop them from using
the document if so. I say it's a mute point because it probably takes a macro
to do so and if they are disabled then the check won't work anyway. But I am
Just wondering.

Thanks,
Rob
 
The most-frequently suggested approach is to hide all sheet except one which
has a "macros must be enabled" message.

If the user has enabled macros then you can use code to unhide the other
sheets and hide the message sheet: if not then they should just "get the
message".

Tim
 
Sweet Idea, I'll give that a try.

Tim Williams said:
The most-frequently suggested approach is to hide all sheet except one which
has a "macros must be enabled" message.

If the user has enabled macros then you can use code to unhide the other
sheets and hide the message sheet: if not then they should just "get the
message".

Tim
Click to expand...
 
Back
Top