Delete All Macros In Workbook

You are amazing! Thank you so much!!

I have tried to run this macro and get the message "the VBProject in Filename is protected or has not components." However, the VBProject is not protected and does have components. What am I doing wrong?

Hi ekr,

This is a macro that deletes all modules in a workbook, including the DeleteAllModules Module. (I'm not the author of the code below)

Please Login or Register  to view this content.

You'll need to go to the vb editor, Tools, References, and enable the "Microsoft Visual Basic for Applications Extensibility"

Hope it helps

I get the following error message "Programmatic access to Visual Basic Project is not trusted."
even with MS Visual Basic for Applications Extensibility enabled.

Go to: File, Options, Trust Center, Trust Center Settings...Macro Settings and tick trust access to the vba project model and also tick enable all macros (take note of the warning). Does it solve the problem?

Yes it worked like a charm - I have 12 modules, and it deleted all but one. All modules have similar name (PT1, PT2, etc) and it deleted all but PT8).

Hmmm....don't really know about that one but try it in other workbooks and see if it deletes all modules. Testing it here, it deletes all modules in my active workbook.

Hi - all is working now.I just increased the number associated with the module in the code to exceed the amount of modules I have by 1 and now all is working

Good to know!