Can't find Macro code

[Guest]

I created a spreadsheet that at one time had some macros in it. Then, I
deleted/removed the macro modules via Visual Basic Editor. However, I
still get a warning (that the spreadsheet has macros) when I open the
spreadsheet. I ran the remove hidden name macroprogram.

 

[Guest]

I am being frustrated by the same problem. I have a workbook containing 140
sheets that gives me the macro warning message when it is opened. The file
does not contain any VB modules. However, in the VB editor, the Window menu
does list two sheets plus ThisWorkbook as containing code, but opening any of
them in the editor does not show any code. In the left dropdown box, I see
listings for Worksheet and Workbook objects (respectively), and clicking on
these will create either a Worksheet_SelectionChange or a Workbook_Open
procedure. I've created and deleted these a number of times and resaved the
file, but I still can't shake Excel thinking it has macros.

 

[Gord Dibben]

rad

Debra Dalgleish has several other things to try.

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

Gord

 

[Guest]

I followed the link to Chris Pearson's site from this one, and used his
procedure for deleting all VBA code in a project, and it seems to have
worked. Curiously, I did have to reset the AutoFilter buttons I have set in
some column header cells. At least the macro warning message has stopped.
Thanks.