Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annoying macro security wont remember my settings | Excel Discussion (Misc queries) | |||
macro security settings | Excel Discussion (Misc queries) | |||
Security Settings | Excel Worksheet Functions | |||
Security Settings | Setting up and Configuration of Excel | |||
macro security settings excel change back to low | Excel Discussion (Misc queries) |