Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make excel auto fill in date and current time | Excel Discussion (Misc queries) | |||
Is there a COMMAND to stop a current process in Excel(Copy/Delete/ | Excel Discussion (Misc queries) | |||
Auto reply in excel forms | Excel Discussion (Misc queries) | |||
Delete Forms CommandButton on Worksheet | Excel Discussion (Misc queries) | |||
Excel :: Creating Entry Forms that auto load a workbook | Excel Programming |