Protected Sheets suppressing object usage

J

Jeff Barnaby

Using a combination of my own intellect and the Microsoft "Learning Tools" online section (I'll trust anything before Microsoft), I've tried everything available to make an object usable after protecting an Excel 2000 spreadsheet, but I keep getting the "The cell or chart you are trying to change is read-only yada yada..." error. In this case, the object is a checkbox, and checking the box will enter an amount into a linked cell. The linked cell itself is unprotected. I've tried unprotecting the checkbox, and that hasn't worked; I've unchecked the "Object" box while protecting the sheet itself, and that hasn't worked either. As it stands, a protected sheet will not allow a user to check or uncheck boxes, and therefore my sheet is useless. What can I try next? Will anything else work?
 
T

Tom Ogilvy

Having the linked cell unlocked (format=>Cells=>Protection tab, uncheck
Locked), protecting only the contents of the sheet (uncheck objects), should
work.

Worked for me with both a control toolbox toolbar checkbox and a chechbox
from the forms toolbar.

If you think you already tried it and it failed, I would suspect that one of
the above properties was not changed.

Tested in xl2000.

--
Regards,
Tom Ogilvy



Jeff Barnaby said:
Using a combination of my own intellect and the Microsoft "Learning Tools"
Click to expand...
online section (I'll trust anything before Microsoft), I've tried everything
available to make an object usable after protecting an Excel 2000
spreadsheet, but I keep getting the "The cell or chart you are trying to
change is read-only yada yada..." error. In this case, the object is a
checkbox, and checking the box will enter an amount into a linked cell. The
linked cell itself is unprotected. I've tried unprotecting the checkbox,
and that hasn't worked; I've unchecked the "Object" box while protecting the
sheet itself, and that hasn't worked either. As it stands, a protected
sheet will not allow a user to check or uncheck boxes, and therefore my
sheet is useless. What can I try next? Will anything else work?
 
Top