Removing a module using VBA
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)
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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
"PCLIVE" wrote in message
...
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
|