Hi there. Unfortunately, I can't see the code that is meant to run when you check those "masters". It's linking to a SS on sharepoint...
Also, you've got multiple overlapping checkboxes - it's going to confuse things massively if you've not done that on purpose. There are 14 checkboxes on your worksheet, but only 8 visible to the user.
Anyway...
Your checkboxes are MS form controls. While some would say steer clear from ActiveX controls, I've never had any problems with them and I find them easier to work with.
If you want to stick with form controls, you'll have to identify which checkboxes you really want to amend and run a macro that changes them. This code is in a standard module:
If you decide to go with ActiveX controls, something like this (this is in the "Sheet1" code):
I'm sure others will be able to elaborate on the pros and cons of either.
HTH
Tim
Bookmarks