Removing a module using VBA

  • Thread starter Thread starter PCLIVE
  • Start date Start date
P

PCLIVE

I'm pretty sure this can be done as I have been able to remove code from
ThisWorkbook.

How can I use VBA code to remove a module...say..."Module1".

Thanks in advanced.
Paul
 
Sub RemoveModule()
With ActiveWorkbook.VBProject
.VBComponents.Remove .VBComponents("Module1")
End With
End Sub

Of course, this requires a reference to the MS VBA extensibility...


HTH,
Bernie
MS Excel MVP
 
No of course about it, it doesn't.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top