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" wrote in message
...
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?