If checkbox is checked, disable the cells

[olga6542]

If the Yes checkbox is checked, I need the table (cells C7:F18) to be disabled.

[AlphaFrog]

Use OptionButtons instead of CheckBoxes

To install the code:

• Right-click on the sheet tab.
• Select View Code from the pop-up context menu.
• Paste the code from below in the worksheet's code module.

Please Login or Register  to view this content.