Phantom Macros?

[John Gregory]

I've copied the form of a worksheet that contained macros to a new workbook
and stripped it of it's formulas throughout the matrix it contained leaving
nothing more than the layout of the form complete with headings and color
schemes.When I open this copy, I'm greated with the message tellin me the
worksheet contains macros. When I go to Tools/Macros on the task bar I find
nothing listed. However, when I use Alt/F11 I find a tree structure listing
the workbook's name followed by a subsection called "Microsoft Excel
Objects" then followed by another subsection called "Sheet 17 (Report (2)"
which is the name of the sheet I copied and striped. But it's not "Sheet 17"
anymore. Immediately under this last entry - on the same level - is an entry
named "This Worksheet". How do I get rid of "Sheet 17" and the window that
appears at startup telling me the worksheet contains macros?

 

[Frank Kabel]

Hi John
you also have to clear the (now empty) modules in the VBA editor.
Directly under the sheet names in the VBA editor should be some module
names. Delete those modules.
Also open each worksheet module and the workbook module: double click
on the entries 'ThisWorkbook' and the sheetnames and clear all code
within these modules.

Also have a look at
http://www.contextures.com/xlfaqMac.html#NoMacros