Macro warning

[Tom Swift]

I received a spreadsheet from someone in my workgroup that opens with the
warning "Macros in this workbook are disabled because the security level is
set to High..." I know for a fact that this spreadsheet has no macros.

I understand that this may occur if an Excel XP file contained a macro that
was removed, but the VBA module that contained the macro was not removed.
When I open the Visual Basic Editor, I cannot find any modules to delete.
What's my next step to stop this warning? Thanks for your help.

Tom Swift

 

[Guest]

Copy the sheet(s) to a new workbook and re-save.

 

[pfsardella]

Tom,

I would right click on each Microsoft Excel Object (sheets,
ThisWorkbook) when you are in the VBE and make sure that there is no
code there.

HTH
Paul
-----------------------------------------------------------------------------------------------------------------