I have a worksheet that says there is a macro when I open
it but it can't be found in the drop down list to delete
it. How do I locate it?

Thanks

Bob,

See http://www.contextures.com/xlfaqMac.html#NoMacros .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bob Potts" wrote in
message ...
I have a worksheet that says there is a macro when I open
it but it can't be found in the drop down list to delete
it. How do I locate it?

Thanks

Debra Dalgleish provides a solution in the FAQ in this Webpage.

All of a sudden, when I open the file, it asks if I want to "Enable or
Disable a Macro". There are no macros in this workbook.

http://www.contextures.com/xlfaqMac.html#NoMacros

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I have a worksheet that says there is a macro when I open
it but it can't be found in the drop down list to delete
it. How do I locate it?

Thanks