How do I find a macro in a worksheet?
Excel 2002 SP3 -
When I open a certain worksheet, I get a pop-up regarding Macros w/ options to enable or disable. The worksheet in question shouldn't contain any macros (I haven't created a macro in years, as a matter of fact). I've gone to "Tools", "Macros", etc. and it doesn't list any. How do I find the macro(s) that are in there, if any? Or is something else causing that message? Thanx, John J. |
How do I find a macro in a worksheet?
John, you most likely need to remove the modules on which the macros were
stored have a look here, for details http://www.contextures.com/xlfaqMac.html#NoMacros -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "JHJ" wrote in message ... Excel 2002 SP3 - When I open a certain worksheet, I get a pop-up regarding Macros w/ options to enable or disable. The worksheet in question shouldn't contain any macros (I haven't created a macro in years, as a matter of fact). I've gone to "Tools", "Macros", etc. and it doesn't list any. How do I find the macro(s) that are in there, if any? Or is something else causing that message? Thanx, John J. |
All times are GMT +1. The time now is 10:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com