How to remove excel macros still there after normal delete?

[Guest]

After removing macros by deleting in the Tools/macro/macros... then delete
them some macros do not delete and the message Enable or Disable Macros comes
up every time the sheet is opened. Is there a way to remove these macros or
tell the Enable Disable window it is no longer applicable?

 

[Chip Pearson]

You need to remove the module in which the macros were stored.
Even an empty module will cause the message to display.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com