Forum Discussion
Excell
The Design Mode button will only be enabled if your workbook contains ActiveX controls and/or VBA code. If it contains neither, the Design Mode button will be grayed out. But that should not affect your ability to use the form controls button.
Also, if you turn on Find & Select > Select Objects on the Home tab of the ribbon, you won't be able to use the command button.
If you mean a Button (Form Control) as in the screenshot below, you only have to click on the sheet outside the button to deselect it. After that, you should be able to use it.
The Design Mode button will only be enabled if your workbook contains ActiveX controls and/or VBA code. If it contains neither, the Design Mode button will be grayed out. But that should not affect your ability to use the form controls button.
Also, if you turn on Find & Select > Select Objects on the Home tab of the ribbon, you won't be able to use the command button.
- Thank you sir