Deleting Macros

[xpnovice]

Having created a couple of macros within a workbook for a particular topic
and then deleting them when they were no longer required, I still get the
"Disable - Enable" Macros prompt when loading the spreadsheet. As there are
no macros associated with this particular spreadsheet can anyone tell me why
it still appears? And how can I prevent it from appearing each time I open
the spreadsheet.

PS. I have also noticed this point previously when simply copying a
worksheet from a workbook containing macros to a new workbook without any
macros.

Thanks in advance

JohnH

 

[Debra Dalgleish]

You also have to remove the module in which the macro was stored, and
any code from the worksheet modules. There are some instructions here:
http://www.contextures.com/xlfaqMac.html#NoMacros