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