Option Button protection on spreadsheet

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Hi
I have (thanks to this newsgroup) successfully set up a
user form leading to a spreadsheet which has options Yes
or No - these answers 1 or 2 are in turn fed into another
sheet with If statements to show text.
Eg: If the user clicks the Yes Option then 1 appears and
in the final sheet =if(A21=1,"Please let us quote
you","Customer already has insurance")
So, everything is working but what I do not want to happen
is that the user clicks on the group box and drags the
position of the option buttons - I have tried to protect
the sheet - contents but then I cannot click on the option
at all - is it possible to protect the sheet so that the
user can only click on certain parts but not anywhere else?

Thanks

Ann
 
You have a linked cell to those optionbuttons. If that cell is locked and the
sheet is protected, then you're stuck (like you wrote).

But if you unlock that cell and reprotect the sheet, then you should be ok.
(You can put this cell in a hidden row, a hidden column or even a different
worksheet (that is hidden).
 
Back
Top