Can't Find Macros

D

DaniBee

I have been messing around with check boxes and Visual Basic in my Control
Toolbox. Somehow I've managed to imbed a macros in my workbook and am
getting the warning message each time the file is opened. I can't seem to
find the macros to delete it. I have 29 worksheets, so it's not an easy
task. When I open my macros, there shows none. How can I find this and
delete it?
 
G

Gord Dibben

ALT + F11 to get to the Visual Basic Editor.

Check for empty modules in your workbook.

These, even though empty, must be removed.

Check for Forms and delete.

Also have a look through the sheets and Thisworkbook for code.

Delete any lines that may be present.

More on this at Debra Dalgeish's site.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros


Gord Dibben Excel MVP
 
Top