Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting form controls by code
Hello
I' like to USE CODE to delete controls from a worksheet. I hope to use the code on several sheets. I used 'Record Macro' to come up with the following, which works well on the 1st sheet ... Application.CommandBars("Drawing").Visible = True ActiveSheet.Shape.Range(Array("chbx1", "chbx2", "optbx1")).Select Selection.Delete Application.CommandBars("Drawing").Visible = False The problem is that different sheets have different numbers of controls, sometimes with different names, so the Array part of the code above crashes. What code can I use to delete all form controls from a given page? Thank you Bri |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting form controls by code
Hi Bri
See http://www.rondebruin.nl/controlsobjectsworksheet.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Bri" wrote in message ... Hello I' like to USE CODE to delete controls from a worksheet. I hope to use the code on several sheets. I used 'Record Macro' to come up with the following, which works well on the 1st sheet ... Application.CommandBars("Drawing").Visible = True ActiveSheet.Shape.Range(Array("chbx1", "chbx2", "optbx1")).Select Selection.Delete Application.CommandBars("Drawing").Visible = False The problem is that different sheets have different numbers of controls, sometimes with different names, so the Array part of the code above crashes. What code can I use to delete all form controls from a given page? Thank you Bri |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting form controls by code
Ron - MOST helpful
Thanks Bri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Form controls | Excel Programming | |||
about more controls of a form | Excel Programming | |||
Deleting worksheets containing ActiveX controls | Excel Programming | |||
Deleting ActiveX Controls | Excel Programming |