Auto delete all VB forms in current excel doc

  • Thread starter Thread starter Martin
  • Start date Start date
M

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
 
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.
 
Back
Top