Delete Macro That's Not There

[TriRyche]

Excel 2003
I have an Excel file that has no Macros that I know of. Every time I open it I receive the Macro warning. I know I can set the security to LOW to stop the warning, but don't want to do that. I cannot delete the "Macro" because I have none in the list.
Any Ideas?
It's not critical, just an annoyance.
Thanks!

 

[carrr]

Hit Alt + F11
This willl open the VB Editor.
On the right hand side, look for the VBA Project Window and select the sheet in question.
Down the "tree" from that sheet, look for any "Modules"
Remove any found...right click on them, select "RemoveModule#" and say No when asked if you want to export.

Tired of waiting for an answer? Try asking better questions. See: faq222-2244

 

[TriRyche]

There does not seem to be any modules under any of the sheets.
The sheets seem to be the lowest items in the tree.

 

[carrr]

Double click on ThisWorkbook and each Sheet (i.e. Sheet1, Sheet2, etc.)
Make sure there is absolutely no code present in any of these modules. If there is, delete it out.

Tired of waiting for an answer? Try asking better questions. See: faq222-2244

 

[TriRyche]

[COLOR=white purple]Thanks!![/color]