Protection of check boxes in excel 2002

N

Newbeetle

Hi I have a form set up in excel with check boxes, and I wish to protect the
sheet but allow users to be able to select and deselect the check boxes.
When I protect the sheet and then use the sheet, an error mesage lets you
know the sheet is protected and read only, I have tried in format control for
the check box to deselect the locked option and lock text option. Its bound
to be simple but help is always welcome.
 
D

Dave Peterson

Try unlocking the cells that are linked to the checkboxes.

You can hide the columns/rows that contain the link (or move them to another
(hidden???) worksheet.
 
N

Newbeetle

Dave Thankyou,

Simple when you know how.


Dave Peterson said:
Try unlocking the cells that are linked to the checkboxes.

You can hide the columns/rows that contain the link (or move them to another
(hidden???) worksheet.
Click to expand...
 
Top