Protection of check boxes in excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Unprotect Combo Box in a Protected Sheet 3
protection 2
hide columns on a protected sheet??? 1
sheet Protection 2
ProtectSheet Options are un-checking after macro 9
how do you "select locked cells" w/o "select unlocked cells"? 3
unprotect check box in protected worksheet 1

Back
Top