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