Macro to delete Macro (Word2000/SR1a & SP2)

Topic

New Reply

We have someone that needs a macro that will delete a macro; she runs a program that writes a temporary macro that is deleted once the process runs through; however, she sometimes crashes and then the temporary macro has to be manually deleted. She wants a toolbar button to accomplish this and for the life of me, I don’t know how to write a macro to delete another macro. Any help out there on this would be greatly appreciated.

Reply | Quote

Replies

The information and code that you need is on Chip Pearson’s site. –Sam

Reply | Quote

Sammy, that all pertained to Excel Workbooks; I need to delete a Word macro.

Reply | Quote

But I don’t think that matters: you’re just using the IDE not anything in the Excel object model. Try it, I think it will work (but I’ve not tried it myself).

Reply | Quote

Perhaps changing ThisWorkbook to ThisDocument is all that would be required. That and setting a reference to the VBA Extensibility library.

If you are okay with deleting an entire module, rather than an individual macro in a module, you can use this one-liner:

Application.OrganizerDelete Source:=NormalTemplate, _
Name:=”Module1“, Object:=wdOrganizerObjectProjectItems

It ruthlessly removes modules without any backup.

Reply | Quote