Now when I open the workbook, the buttons don't work! When I click them nothing happens. Then I saved and closed the workbook and went to lunch. I added the _Click code to run the macros when the user clicked the buttons.Īll of the buttons were working fine. I got into the button properties and set the background colors. So I removed the form control buttons and created new ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color.
I'm having a problem in a workbook with several ActiveX command buttons.
