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
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