Macro security warning message

[Jeff Hasty]

When I recorded a macro in my spreadsheet, I began
getting a message when opening the spreadsheet: "Macros
in this workbook are disabled because security is
high...". I have deleted all macros, but the message
persists. How do I keep security set on high, and get
rid of this message. Spreadsheets that have never had a
macro recorded don't have this message, even with
security set on high. I am using Windows XP and Excel
2002.

 

[Nick Hodge]

Jeff

You may have deleted the code, but you need to delete the modules that
contained them too.

Open the VBE (alt+F11), select the modules you wish to delete in the project
explorer and right click them. Select remove module xxx and answer no to
exporting it. (Repeat as necessary)

Close the VBE and save the workbook. (If these were recorded it is all that
is needed. If code was written it may also reside 'behind' the objects,
Sheets, workbook, etc. In this case it is only necessary for these to have
the code deleted).