I would like to use a Form Control checkbox to change the protection and fill color of a cell. The TRUE condition should unlock the cell and change the color to a light yellow, the FALSE condition changes things back to locked and no-fill state. I've tried a few things but mostly found that the solutions are designed for ActiveX controls and not for a Forms Control checkbox, which I need to compatibility with Apple versions of Excel.
Any assistance with proper code would be greatly appreciated.
Bookmarks