I have a spreadsheet (Excel 2003) in which I have 2 option buttons grouped
together to give an either/or choice. These are linked to a cell which return
the result of which one is selected. Another formula references this cell to
insert specific information in a second worksheet within the file.

I want to protect both worksheets and have unlocked cells where the user
needs to enter data. My problem is how can I unprotect/unlock the option
buttons. Whatever I try results in an error massage re the sheet being
protected. My fornulas work but this will confuse users so I don't want the
warning shoing.

Grateful for any pointers.