Removing a module using VBA

[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

 

[Guest]

see:

http://www.cpearson.com/excel/vbe.htm

 

[Bernie Deitrick]

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

 

[Bob Phillips]

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)

 

[PCLIVE]

Thanks.
I forgot to check Chip's site. Works great!