Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to delete all the commandbuttons in the entire
workbook? I found some code below that does it for a single sheet. Thanks! Sub DeleteCommandButtons() Dim Obj As OLEObject For Each Obj In ActiveSheet.OLEObjects If Obj.progID = "Forms.CommandButton.1" Then Obj.Delete End If Next Obj End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
CommandButtons | Excel Programming | |||
Commandbuttons | Excel Programming | |||
delete commandbuttons on copied sheet | Excel Programming | |||
commandbuttons properties | Excel Programming |