 |
 | 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 / New Users / April 2008Excel 2003 sticks to the low macro security level
Hello! Excel 2003 sp2 and sp3 do not remember the macro security level. Excel returns the level to low after any change of the level. How to prevent a macro to run when Excel 2003 sp2 and sp3 open a file with a macro? Best regards Dima That's one of the settings that's stored in the windows registry. If it's not sticking, maybe you don't have permission to update the registry? Time to talk to the IT folks????? If you're opening the file manually, you can old the shift (left shift???) key down while you open the workbook. This won't stop macros in general, but it will stop the auto_open and workbook_open procedures from running. > Hello! > Excel 2003 sp2 and sp3 do not remember the macro security level. Excel [quoted text clipped - 3 lines] > Best regards > Dima  SignatureDave Peterson Thanks Dave for replying! I talked to the system and domain administrators. They blame microsoft, do not know how to repair. I've found the http://support.microsoft.com/kb/910817/en-us Should I delete the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Excel\Security to repair? I have the administrator rights on my Windows XP. Sincerely. > That's one of the settings that's stored in the windows registry. > [quoted text clipped - 18 lines] >> Best regards >> Dima If you found that branch in the registry, I wouldn't delete it. I'd just change it what I wanted: 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". 1 = low, 2 = medium, 3 = high. ====== ps. I'm not a IT expert, but it sure sounds more like a problem with the permissions than excel/Microsoft. > Thanks Dave for replying! > I talked to the system and domain administrators. They blame microsoft, do [quoted text clipped - 30 lines] > > > > Dave Peterson SignatureDave Peterson Thanks Dave for suggestion! This allows to set another than the low level, doesn't it? How to make Excel remember a setting in its user interface? Sincerely. > If you found that branch in the registry, I wouldn't delete it. > [quoted text clipped - 48 lines] >> > >> > Dave Peterson The problem is that you should be able to make that change through the user interface and excel should remember it. It's quite unusual that you can't do this. I _think_ that in all the posts that describe this problem, it usually comes down to a permissions setting that the IT staff put on the users. That's why I think it's not excel's problem, it's you're IT staff's problem. > Thanks Dave for suggestion! > This allows to set another than the low level, doesn't it? How to make Excel [quoted text clipped - 56 lines] > > > > Dave Peterson SignatureDave Peterson ... it's _your_ IT staff's problem. (stupid fingers!) > The problem is that you should be able to make that change through the user > interface and excel should remember it. It's quite unusual that you can't do [quoted text clipped - 68 lines] > > Dave Peterson SignatureDave Peterson Thanks Dave for replying! Our IT staff says that they did not put any LOCAL restrictions on me. I have full LOCAL administrator rights. Sincerely. > The problem is that you should be able to make that change through the > user [quoted text clipped - 75 lines] >> > >> > Dave Peterson I don't have another guess. Good luck. If you find the solution, please post back so that google has it. > Thanks Dave for replying! > Our IT staff says that they did not put any LOCAL restrictions on me. I have [quoted text clipped - 83 lines] > > > > Dave Peterson SignatureDave Peterson Dave- This may not be it for the OP but if the "Level" entry exists under HKLM: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Excel\Security Then it is sticky. It allows you to change it for the current session but the HKLM setting remains the default. I have no idea how the HKLM gets set initially though. SignatureJim >I don't have another guess. > [quoted text clipped - 93 lines] >> > >> > Dave Peterson I hope the OP is still hanging around. I remember other posts that describe the same stickyness problem with the "trust access to Visual Basic project" (IIRC). Here's hoping that this fixes it. > Dave- > [quoted text clipped - 109 lines] > > > > Dave Peterson SignatureDave Peterson Thanks Jim for replying! Should I delete the "Level" entry under HKLM\SOFTWARE\Microsoft\Office\11.0\Excel\Security ? How is OP interpreted? Sincerely. >I hope the OP is still hanging around. > [quoted text clipped - 131 lines] >> > >> > Dave Peterson OP = Original Poster. For me, I don't have this key. You may want to rename it (SecurityX, maybe). Then test it out. If that fixes the problem, I'd delete the key. > Thanks Jim for replying! > Should I delete the "Level" entry under [quoted text clipped - 140 lines] > > > > Dave Peterson SignatureDave Peterson Deleting the Level entry resolved the problem! Thanks Dave! > OP = Original Poster. > [quoted text clipped - 158 lines] >> > >> > Dave Peterson Thanks for posting back. I'm sure Jim appreciates the feedback, too. > Deleting the Level entry resolved the problem! > Thanks Dave! [quoted text clipped - 164 lines] > > > > Dave Peterson 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.