ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to remove excel macros still there after normal delete? (https://www.excelbanter.com/excel-discussion-misc-queries/84313-how-remove-excel-macros-still-there-after-normal-delete.html)

James

How to remove excel macros still there after normal delete?
 
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

How to remove excel macros still there after normal delete?
 
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


"James" wrote in message
...
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?





All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com