MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protecting a worksheet with option buttons

Posted by Linda on July 26, 2001 8:39 AM

I would like to protect a worksheet, but still allow the user to change the option buttons. I have unlocked the buttons and the group boxes in the properties window, but when I protect the spreadsheet, I get the "cells protected" message when trying to change the option buttons. I have even unlocked the cells underneath the option buttons, but nothing seems to work. Any ideas?

Posted by lenze on July 26, 2001 9:31 AM

Linda: Make sure the cell the option buttons are referenced to is unlocked. Also, the form option buttons are usually easier to work with than the control option buttons