Macros

[Guest]

I have deleted all of the macros in a workbook, but the Enable/Disable macros
prompt still appears when opening the workbook. How do I remove that without
changing security settings?

 

[Norman Jones]

Hi Brian,

You need to delete the empty modules.

See also Debra Dalgleish's notes at:

http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Guest]

Brian,
You may also have Excel version 4 macros in a hidden worksheet.
HTH,
Gary Brown