 |
 | 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 / March 2007How to stop warning about non-existent macros?
An XLS file (workbook) of mine contained a macro that I never used, and I was annoyed that whenever I opened it I was warned: [filename] contains macros. Macros may contain viruses. It is always safe to disable macros, but if the macros are legitimate, you might lose some functionality. [Disable Macros] [Enable Macros] [More Info] So I went to Tools/Macro/Macros, selected the only macro, hit Delete and it was gone. Then I saved my file. But now when I open the file, I still get the same warning, and if I go Tools/Macro/Macros the list is blank. How can I eliminate the "contains macros" warning for a workbook which does not, in fact, contain any macros? I get the same warning whether opening the file in Excel 2000 or 2003. - Rich Open the file. Hit Alt+F11. You should see a Module on the left-hand side. Right-click it and remove it, telling it you do NOT want to export it first. For more information/graphics to show you how: http://www.officearticles.com/excel/remove_vba_code_from_a_workbook_in_microsoft _excel.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** > An XLS file (workbook) of mine contained a macro that I never used, > and I was annoyed that whenever I opened it I was warned: [quoted text clipped - 16 lines] > > - Rich Wow, that fixed it! Anne, you're a genius! Thank you so much! Other than asking my question here as I did (or discovering your web page on my own), how could I have guessed that solution? I had opened Excel Help and searched for "remove macros" and every other combination of keywords I could think of and the answer just wasn't there. - Rich > Open the file. Hit Alt+F11. You should see a Module on the left-hand side. > Right-click it and remove it, telling it you do NOT want to export it first. [quoted text clipped - 26 lines] >> >> - Rich That's why we're here, Rich. :) So glad I could help! **************************** Anne Troy www.OfficeArticles.com **************************** > Wow, that fixed it! Anne, you're a genius! Thank you so much! > [quoted text clipped - 37 lines] >>> >>> - Rich |
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.