How to Find/Delete Macro in Excel workbook?

[Will Deatrick]

How can I find what macros are defined in an Excel 2004 f/Mac
workbook? The workbook itself was created years ago under earlier an
earlier version of Excel.

When I open this particular workbook, Excel 2004 warns me that the
workbook contains macros. There shouldn't be any macros in the
workbook, so I open with "Disable Macros". I then selected
Tools->Macro->Macros... to see what macros are defined, but no macros
are shown. Excel help mentions XLM macros can't be disabled, but
doesn't state if they should appear in the macro list.

When I dump the workbook contents, I can see text near the bottom that
mentions "Visual Basic for IUH" and "VBAProject", and "stdole" (a
Dynamic Link Library?), but I don't know how to decode this into
anything meaningful. I would like to delete whatever macros are in this
workbook.

Thanks, Will

 

[JE McGimpsey]

How can I find what macros are defined in an Excel 2004 f/Mac
workbook? The workbook itself was created years ago under earlier an
earlier version of Excel.

First thing to check: Type Opt-F11 to open the Visual Basic Editor. If
there are any regular code modules or userforms in your Project (see

http://www.mcgimpsey.com/excel/modules.html

for more). If there are, delete them.

Check that there are no visible or hidden Macro sheets (usually with a
name like Macro1).

Also check the ThisWorkbook and Sheet code modules to see if there is
any code in them. If there is any text at all, delete it.

Next, check Insert/Name/Define to see if there are any defined names
that use XL4M calls (e.g., something like ?=GET.CELL(...)).