Auto delete all VB forms in current excel doc

[Martin]

Not sure if this will be possible, but I'm trying to put
together some code which removes all Vis Basic Forms from
the current excel document without having to go into the
visual basic editor.

Thanks

 

[Tom Ogilvy]

Look at Chip Pearson's site
http://ww.cpearson.com/excel/vbe.htm

 

[Chip Pearson]

Martin,

Set a reference in VBA to the MS VBA Extensibility library, and then use the
following code:

Dim VBComp As VBIDE.VBComponent
With ActiveWorkbook.VBProject
For Each VBComp In .VBComponents
If VBComp.Type = vbext_ct_MSForm Then
.VBComponents.Remove VBComp
End If
Next VBComp
End With


See www.cpearson.com/excel/vbe.htm for more details.