Macro security settings
 

Kelly,

No code will run if their setting is on High.

Create a "Welcome" sheet with your message.
Than in the Workbook_Open event you can hide this sheet.

This way - if they don't have macros enabled - they see the "Welcome"
If they do have them enabled - they don't see it.

You can get fancy with the following alternatives:
1. Hide all sheets, except the Welcome sheet unless macros are enabled.
2. Delete the Welcome sheet if macros are enabled.
3. Hide and unhide sheets on opening.

Hope this gives you some ideas...

steve
"Kelly" wrote in message
...
Hi all, I'm using the Office 2000 package.

Does anyone know of code that will prompt the user to
change their macro security settings to medium or low??

I have a spreadsheet for company use and if the user logs
in to a PC other then their own the security settings on
Excel macros automatically default to "high" when this
happens then of course my "Workbook-Activate" code will
not run and it won't even prompt the user??

Any ideas? I managed to get most of the PC's changed over
but like I say, if they log onto a PC they have not used
before then their settings for Excel are defaulted back
to "high".

Thanks

Kelly

Macro security settings
 

I wouldn't delete the Welcome sheet, just hide it. What if the user sets security back to High?
Then he's back tothe situation he's in now.

On Mon, 11 Aug 2003 11:34:22 -0700, "steve" wrote:

Kelly,

No code will run if their setting is on High.

Create a "Welcome" sheet with your message.
Than in the Workbook_Open event you can hide this sheet.

This way - if they don't have macros enabled - they see the "Welcome"
If they do have them enabled - they don't see it.

You can get fancy with the following alternatives:
1. Hide all sheets, except the Welcome sheet unless macros are enabled.
2. Delete the Welcome sheet if macros are enabled.
3. Hide and unhide sheets on opening.

Hope this gives you some ideas...

steve
"Kelly" wrote in message
...
Hi all, I'm using the Office 2000 package.

Does anyone know of code that will prompt the user to
change their macro security settings to medium or low??

I have a spreadsheet for company use and if the user logs
in to a PC other then their own the security settings on
Excel macros automatically default to "high" when this
happens then of course my "Workbook-Activate" code will
not run and it won't even prompt the user??

Any ideas? I managed to get most of the PC's changed over
but like I say, if they log onto a PC they have not used
before then their settings for Excel are defaulted back
to "high".

Thanks

Kelly