Protection of check boxes in excel 2002
 

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.

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.

Newbeetle wrote:

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

Dave Thankyou,

Simple when you know how.


"Dave Peterson" wrote:

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.

Newbeetle wrote:

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