LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
detecting proxy settings Russell Johnson Excel Discussion (Misc queries) 0 February 26th 07 01:16 AM
Detecting Macro Security Level Ed Ferrero[_5_] Excel Programming 0 June 15th 04 01:22 PM
Detecting Macro Security Level arkimediz Excel Programming 0 June 15th 04 11:47 AM
Detecting Macro Code behind a sheet (2) Chris Gorham[_3_] Excel Programming 10 December 31st 03 06:12 PM
Detecting Macro code behind a sheet Chris Gorham[_3_] Excel Programming 3 December 31st 03 01:39 AM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"