I’m using Excel 2000. Am setting up a Questionaire. Have used Check Boxes and they drive anewers that give me numbers to summarise & have hidden these. So all is going well.
What I want to do now is protect the work sheet – so that all the user can do is to check or un-check a box. I have gone to “Format Control” & on the Protection Tab unLocked protection. Then Protected work sheet. When I do this I can’t tick or un-tick a check box – I get the standard “this sheet is protected” type message .
I guess this must be a common prob & the is probably a really simple answer – but it’s eluding me right now!!! Can any body help? Thanks in anticipation!
Regards Mike
