 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / November 2004Disable Excel Macro Message
Is there a way to disable the Enable/Disable Macro message on a workbook containing a macro so that any user opening the workbook will not be prompted with that message? Thanks, Chris 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. > Is there a way to disable the Enable/Disable Macro message on a workbook > containing a macro so that any user opening the workbook will not be [quoted text clipped - 3 lines] > > Chris  SignatureDave Peterson > 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 You changed this setting on a user's pc and they still got the message???? > > There's a setting that each user can change -- but you can't do it for them in > > your workbook. [quoted text clipped - 7 lines] > > Chris SignatureDave Peterson Yes it still comes up I tried it on multiple machines. Thanks, Chris > You changed this setting on a user's pc and they still got the message???? > [quoted text clipped - 9 lines] >> >>Chris 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. > Yes it still comes up I tried it on multiple machines. > [quoted text clipped - 15 lines] > >> > >>Chris SignatureDave Peterson 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 > I've never seen any prompt when the setting was on low. > [quoted text clipped - 26 lines] >>>> >>>>Chris >>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\Excel\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. > 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 [quoted text clipped - 34 lines] > >>>> > >>>>Chris SignatureDave Peterson oops. I omitted the first line when I copied/pasted. This was originally posted by Jim Rech. > >>Where in user profiles - or elsewhere- is this setting saved. > [quoted text clipped - 55 lines] > > Dave Peterson SignatureDave Peterson 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 >>>Where in user profiles - or elsewhere- is this setting saved. > [quoted text clipped - 51 lines] >>>>>> >>>>>>Chris 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 >>>Where in user profiles - or elsewhere- is this setting saved. > [quoted text clipped - 51 lines] >>>>>> >>>>>>Chris 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.) > Well no luck it was already set to 1. Oh well my user may just have to > live with it. [quoted text clipped - 58 lines] > >>>>>> > >>>>>>Chris SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.