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
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