Disable Form button

[BMD44]

I have included Button from 'Form controls' in Excel.

Now, I want the button to be disabled when I open the workbook.

I used below syntax, but it doesn't disable the button.

ActiveSheet.Shapes("Button 1").ControlFormat.Enabled = False

The same syntax works for Command button

ActiveSheet.Shapes("CommandButton1").ControlFormat.Enabled = False

Can any one please help how can we disable Form Controls - Button.

Thanks in advance

 

[mikerickson]

One workaround for disabling a Forms control command button would be to toggle the OnAction property between the name of its macro and "".