Auto delete all VB forms in current excel doc
 

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

Auto delete all VB forms in current excel doc
 

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

--
Regards,
Tom Ogilvy


"Martin" wrote in message
...
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

Auto delete all VB forms in current excel doc
 

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Martin" wrote in message
...
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