Detecting Macro Secutiry Settings
 

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

Detecting Macro Secutiry Settings
 

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




"Rob" wrote in message
...
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

Detecting Macro Secutiry Settings
 

Sweet Idea, I'll give that a try.

"Tim Williams" wrote:

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




"Rob" wrote in message
...
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