Macro warning

  • Thread starter Thread starter Tom Swift
  • Start date Start date
T

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
 
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
-----------------------------------------------------------------------------------------------------------------
 
Back
Top