Jan 23 2022 05:31 AM
I made a form button but cant close design mode to use button
Jan 23 2022 06:13 AM - edited Jan 23 2022 06:14 AM
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.
Jan 23 2022 06:18 AM
Jan 23 2022 06:37 AM
SolutionThe 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.
Jan 23 2022 06:37 AM
SolutionThe 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.