Remove modules & Forms

[JONBOY74]

Hi all

What is the VBA code for removing forms and code from a project. I've managed to add them but I'm now stuck.

Please help

Thanks

Jon

 

[vbMax]

Before using these procedures, you'll need to
go into the VBA editor, go to the Tools menu,
choose the References item, and put a check
next to "Microsoft Visual Basic For
Applications Extensibility" library.


Sub delModule()

Dim VBComp As VBComponent
Set VBComp = ThisWorkbook.VBProject.VBComponents("Module1&quot
ThisWorkbook.VBProject.VBComponents.Remove VBComp

End Sub



Sub delForm()

Dim VBComp As VBComponent
Set VBComp = ThisWorkbook.VBProject.VBComponents("UserForm1&quot
ThisWorkbook.VBProject.VBComponents.Remove VBComp


End Sub