If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Disable Excel Macro Message
I've never seen any prompt when the setting was on low.
After you change this setting, try closing excel, then reopen excel. Check that setting once more. I've seen lots of posts that complain that their IT folks didn't give them permission to change the registry (for keeps). If you find that the setting doesn't "stick", I think it's time to ask your IT folks. Chris wrote: Yes it still comes up I tried it on multiple machines. Thanks, Chris Dave Peterson wrote: You changed this setting on a user's pc and they still got the message???? Chris wrote: Dave Peterson wrote: There's a setting that each user can change -- but you can't do it for them in your workbook. Tools|macros|security|security tab is where they'll find it. If it's changing the security level to low, that's not working. Any other ideas? Thanks, Chris -- Dave Peterson |
#2
|
|||
|
|||
I am the IT folks I even rebooted after changing the setting not
that it would make a difference but still no change. If there is a registry setting that can be changed do you happen to know which it is? Thanks, Chris Dave Peterson wrote: I've never seen any prompt when the setting was on low. After you change this setting, try closing excel, then reopen excel. Check that setting once more. I've seen lots of posts that complain that their IT folks didn't give them permission to change the registry (for keeps). If you find that the setting doesn't "stick", I think it's time to ask your IT folks. Chris wrote: Yes it still comes up I tried it on multiple machines. Thanks, Chris Dave Peterson wrote: You changed this setting on a user's pc and they still got the message???? Chris wrote: Dave Peterson wrote: There's a setting that each user can change -- but you can't do it for them in your workbook. Tools|macros|security|security tab is where they'll find it. If it's changing the security level to low, that's not working. Any other ideas? Thanks, Chris |
#3
|
|||
|
|||
Where in user profiles - or elsewhere- is this setting saved.
The Excel security setting is saved in the registry under this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security This is for Excel 2003. Should be something similar for other versions. The item is "Level". You'd set this to 2 for medium === and just to add: 1 = low, 2 = medium, 3 = high. ======= So the setting reverted back each time you closed excel--just curious. Chris wrote: I am the IT folks I even rebooted after changing the setting not that it would make a difference but still no change. If there is a registry setting that can be changed do you happen to know which it is? Thanks, Chris Dave Peterson wrote: I've never seen any prompt when the setting was on low. After you change this setting, try closing excel, then reopen excel. Check that setting once more. I've seen lots of posts that complain that their IT folks didn't give them permission to change the registry (for keeps). If you find that the setting doesn't "stick", I think it's time to ask your IT folks. Chris wrote: Yes it still comes up I tried it on multiple machines. Thanks, Chris Dave Peterson wrote: You changed this setting on a user's pc and they still got the message???? Chris wrote: Dave Peterson wrote: There's a setting that each user can change -- but you can't do it for them in your workbook. Tools|macros|security|security tab is where they'll find it. If it's changing the security level to low, that's not working. Any other ideas? Thanks, Chris -- Dave Peterson |
#4
|
|||
|
|||
oops.
I omitted the first line when I copied/pasted. This was originally posted by Jim Rech. Dave Peterson wrote: Where in user profiles - or elsewhere- is this setting saved. The Excel security setting is saved in the registry under this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security This is for Excel 2003. Should be something similar for other versions. The item is "Level". You'd set this to 2 for medium === and just to add: 1 = low, 2 = medium, 3 = high. ======= So the setting reverted back each time you closed excel--just curious. Chris wrote: I am the IT folks I even rebooted after changing the setting not that it would make a difference but still no change. If there is a registry setting that can be changed do you happen to know which it is? Thanks, Chris Dave Peterson wrote: I've never seen any prompt when the setting was on low. After you change this setting, try closing excel, then reopen excel. Check that setting once more. I've seen lots of posts that complain that their IT folks didn't give them permission to change the registry (for keeps). If you find that the setting doesn't "stick", I think it's time to ask your IT folks. Chris wrote: Yes it still comes up I tried it on multiple machines. Thanks, Chris Dave Peterson wrote: You changed this setting on a user's pc and they still got the message???? Chris wrote: Dave Peterson wrote: There's a setting that each user can change -- but you can't do it for them in your workbook. Tools|macros|security|security tab is where they'll find it. If it's changing the security level to low, that's not working. Any other ideas? Thanks, Chris -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Thanks I'll give that a try and see if it works. No the setting
wouldn't revert back it stayed on low but still gives me the macros message. We are using Office 2003. Thanks, Chris Dave Peterson wrote: Where in user profiles - or elsewhere- is this setting saved. The Excel security setting is saved in the registry under this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security This is for Excel 2003. Should be something similar for other versions. The item is "Level". You'd set this to 2 for medium === and just to add: 1 = low, 2 = medium, 3 = high. ======= So the setting reverted back each time you closed excel--just curious. Chris wrote: I am the IT folks I even rebooted after changing the setting not that it would make a difference but still no change. If there is a registry setting that can be changed do you happen to know which it is? Thanks, Chris Dave Peterson wrote: I've never seen any prompt when the setting was on low. After you change this setting, try closing excel, then reopen excel. Check that setting once more. I've seen lots of posts that complain that their IT folks didn't give them permission to change the registry (for keeps). If you find that the setting doesn't "stick", I think it's time to ask your IT folks. Chris wrote: Yes it still comes up I tried it on multiple machines. Thanks, Chris Dave Peterson wrote: You changed this setting on a user's pc and they still got the message???? Chris wrote: Dave Peterson wrote: There's a setting that each user can change -- but you can't do it for them in your workbook. Tools|macros|security|security tab is where they'll find it. If it's changing the security level to low, that's not working. Any other ideas? Thanks, Chris |
#6
|
|||
|
|||
Well no luck it was already set to 1. Oh well my user may just have to
live with it. Thanks for your help, Chris Dave Peterson wrote: Where in user profiles - or elsewhere- is this setting saved. The Excel security setting is saved in the registry under this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security This is for Excel 2003. Should be something similar for other versions. The item is "Level". You'd set this to 2 for medium === and just to add: 1 = low, 2 = medium, 3 = high. ======= So the setting reverted back each time you closed excel--just curious. Chris wrote: I am the IT folks I even rebooted after changing the setting not that it would make a difference but still no change. If there is a registry setting that can be changed do you happen to know which it is? Thanks, Chris Dave Peterson wrote: I've never seen any prompt when the setting was on low. After you change this setting, try closing excel, then reopen excel. Check that setting once more. I've seen lots of posts that complain that their IT folks didn't give them permission to change the registry (for keeps). If you find that the setting doesn't "stick", I think it's time to ask your IT folks. Chris wrote: Yes it still comes up I tried it on multiple machines. Thanks, Chris Dave Peterson wrote: You changed this setting on a user's pc and they still got the message???? Chris wrote: Dave Peterson wrote: There's a setting that each user can change -- but you can't do it for them in your workbook. Tools|macros|security|security tab is where they'll find it. If it's changing the security level to low, that's not working. Any other ideas? Thanks, Chris |
#7
|
|||
|
|||
Sorry I couldn't help.
If you've seen this with your own eyes, then ignore this. But I'd watch to see that warning message. Maybe the user isn't remembering the message correctly. (Yeah, it's a long shot--but I got nothin' else.) Chris wrote: Well no luck it was already set to 1. Oh well my user may just have to live with it. Thanks for your help, Chris Dave Peterson wrote: Where in user profiles - or elsewhere- is this setting saved. The Excel security setting is saved in the registry under this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security This is for Excel 2003. Should be something similar for other versions. The item is "Level". You'd set this to 2 for medium === and just to add: 1 = low, 2 = medium, 3 = high. ======= So the setting reverted back each time you closed excel--just curious. Chris wrote: I am the IT folks I even rebooted after changing the setting not that it would make a difference but still no change. If there is a registry setting that can be changed do you happen to know which it is? Thanks, Chris Dave Peterson wrote: I've never seen any prompt when the setting was on low. After you change this setting, try closing excel, then reopen excel. Check that setting once more. I've seen lots of posts that complain that their IT folks didn't give them permission to change the registry (for keeps). If you find that the setting doesn't "stick", I think it's time to ask your IT folks. Chris wrote: Yes it still comes up I tried it on multiple machines. Thanks, Chris Dave Peterson wrote: You changed this setting on a user's pc and they still got the message???? Chris wrote: Dave Peterson wrote: There's a setting that each user can change -- but you can't do it for them in your workbook. Tools|macros|security|security tab is where they'll find it. If it's changing the security level to low, that's not working. Any other ideas? Thanks, Chris -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Macro help please: Excel data to word doc | anna-maria | General Discussion | 5 | June 30th, 2004 11:53 PM |
Excel Macro Pop-up Message | Derek | Worksheet Functions | 1 | March 2nd, 2004 12:56 AM |
Need VBA code or MACRO to disable the printing of Excel worksheets | Marcello do Guzman | Worksheet Functions | 2 | November 15th, 2003 06:42 PM |