Protection of check boxes in excel 2002

[Guest]

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.

 

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

 

[Guest]

Dave Thankyou,

Simple when you know how.

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.