Disable ActiveX checkbox based on Value

Good afternoon, ladies and gents!

I have a column that will be filled with around 3000 ActiveX checkboxes. I would like to use either Worksheet_change or worksheet_calculate event to see if there's a change in column N boolean value is true then disable object from being pressed again. Below is my code that I'm working with. Thanks in advanced for the help!

Please Login or Register  to view this content.

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.