how to disable/enable command button (ActiveX) using a macro
You're welcome.
Keiji
enahs_naneek wrote:
Thank you keiji - it worked perfectly
_______________________________
keiji kounoike wrote:
There are some ways to disable commandbutton.
One way is
Sub Disable()
ActiveSheet.OLEObjects("CommandButton1").Enabled = False
End Sub
Keiji
Thank you for your reply
I have entered the code you provided within my "Disable" macro (shown below)
[quoted text clipped - 46 lines]
[quoted text clipped - 13 lines]
Any help much appreciated
|