It was put on with the forms toolbar.

"Rick Rothstein (MVP - VB)" wrote:

If the button on the worksheet was an ActiveX button control from the
Control Toolbox toolbar, then you could put this in the UserForm's
CommandButton's Click event...

Worksheets("Sheet1").CommandButton1.Enabled = False

Change the worksheet reference and name of the button on the worksheet to
match your actual conditions.

Rick


"ranswrt" wrote in message
...
Is there a way to set a button on a worksheet to enable = false like with
a
commandbutton on a userform? Will the text lighten to show that it is
disabled?