Remove Duplicate Macros

[gtd526]

Hello,

Can you delete duplicate Macro's from a Module using a macro?
I want to delete duplicate macros using the "Macro Name", except for 1, I need 1 to perform.
I have many Modules. I can change the "Module Name" needed for the code.
If I delete all duplicates in one shot, I won't know which ones were deleted, which will effect "buttons" I have to perform certain Macros.
I can change the VBAProject (Worksheet Name) to determine where the Modules are located, if needed.

Thank you.

 

[JLGWhiz]

My suggestion is to manage your macros manually. any deletions by a macro are permanent and cannot be undone with the 'Undo' button.

 

[gtd526]

My suggestion is to manage your macros manually. any deletions by a macro are permanent and cannot be undone with the 'Undo' button.

Thank you. Is there a way to List Macros? It will take a while to view and list them all.

 

[gtd526]

Thank you. Is there a way to List Macros? It will take a while to view and list them all.

I found a solution. This Macro will list procedures and macros.
It creates a workbook with the listings.

List VBA Procedures by VBA Module and VB Procedure - Peltier Tech

Mathias Brandewinder of Clear Lines Blog tweeted up Displaying a List of All VBA Procedures in an Excel 2007 Workbook from the Ribbon, an article by Microsoft’s Frank Rice on the MSDN web site, which showed a VBA procedure for listing all of the VBA procedures in a VB project. Interesting...

peltiertech.com

 

[JLGWhiz]

Thanks for the feedback.
Regards, JLG