View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Delete Commandbutton?

Hi BlueGnu,

Try:

'=============
Private Sub CommandButton1_Click()
Dim MyButton As OLEObject
On Error Resume Next
Set MyButton = ThisWorkbook.Sheets("Sheet2"). _
OLEObjects("Commandbutton5")
On Error GoTo 0
If Not MyButton Is Nothing Then
MyButton.Delete
Else
MsgBox "CommandButton already deleted or not found"
End If

End Sub
'<<=============


---
Regards,
Norman



"bluegnu" wrote in
message ...

I'd like to be able to press one command button which deletes another
command button on a different worksheet - is this possible?

many thanks


--
bluegnu
------------------------------------------------------------------------
bluegnu's Profile:
http://www.excelforum.com/member.php...o&userid=36108
View this thread: http://www.excelforum.com/showthread...hreadid=559824