Delete macros so that security warning disappears

[Jim Birch]

Using Excel 2002, Windows XP Pro...

I built a start-up (Auto_Open) macro for a workbook
template. However, the client was reluctant to include
any macros since he feared that the macro security
warning might scare off his customers who keep there
security settings at medium or high. He asked me to
delete the macro. I deleted it from the template and
saved the template under a new name, but I still get the
macro security warning when I start the template. When I
do Tools|Macro|Macros... command, no macros are listed.

I did have the VBA code self certified, but I removed the
certificate as well. Any suggestions?

 

[Frank Kabel]

Hi Jim
you also have to completly remove the modules in your workbook (even if
they are empty).
See http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Ken Wright]

You need to delete any empty modules that housed those macros.

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane you
need to search for
your workbook's name, and when you find it you may need to click on the + to
expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook
Modules
Module1
Module2
etc etc (You may have just 1 of these)

If you have named your sheets then those names will appear in the brackets above
as opposed to
what you see at the moment in my note.

Right click on the modules and select remove. When prompted with a question re
exporting, just
hit no. Then hit File / Close and return to Microsoft Excel and save the file.