Command buttons not working

Question

I have started having issues with command buttons. Note the first image with the green command button. I normally get that outline when "Design Mode" is clicked. However, it is not in this first image. In the second image, the design mode IS activated and the outline of the green command button is as it should be at that point.

I cannot use any of the command buttons in this workbook.

How can I fix this?

Answer 1

I have never had to assign a command button to code. I initially create the command button, then right-click to view code. At this point, I type out the code and the command button will execute that code when clicked.

The command buttons were working great on my other laptop before I bought this new one and copied the workbook to the new laptop.

I also do not understand the reference to "sharp instead of control."

Answer 2

If the file is working on another computer. It should be incorrect setting on your new laptop.

Could you share your macro settings?

Could you share your office version? File >account>about Excel

Answer 3

This is a relatively common occurrence with activex controls if an office update changes the forms library. Try closing all office applications, then searching for and deleting any .exd (not .exe !) files on your computer. Those are temp files that office creates when activex controls are used.

Answer 4

The setting was originally on one of the "Disable...." options. I picked the "Enable...." option and used different combinations of it and the two checked boxes to no avail.

Answer 5

I found one file with that extension and deleted it but that did not fix it.