I have set up a button to "click" checkboxes or change their value to 1. I am using form controls instead of ActiveX controls because I have Mac users who will be using the template.
When I click the button the checkboxes are marked as if they are checked and the linked cells show TRUE, but the macro assigned to the checkbox does not run. When I manually click each checkbox, the assigned macro will run.
Here's the code I use for the button:
Here's the code I use for each checkbox:Please Login or Register to view this content.
Any help is greatly appreciated! Thanks in advance!Please Login or Register to view this content.
I also asked this question in another forum : https://www.mrexcel.com/forum/excel-...on-clicks.html
Bookmarks