Worksheet Object Protection

C

Christmas May

I have an Excel worksheet with several text boxes and "objects/controls" that
were added from the "Control Toolbox" not from the "Forms" toolbox. I'm now
ready to "deploy" my worksheet/book and would like to lock EVERYTHING except
my end users ability to select the various check boxes, raido buttons, etc.
I can lock/protect it to generate an error when someone selects the objects,
or I can unprotect it so the end user can accidentially re-arrange/delete the
option buttons.

Please assist with providing an intermeiate security feature that would
allow the end user to select the various buttons without getting an error,
however, would not allow them to modify, move, or delete the buttons that are
already there.

Sincerely,

Christmas May
 

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

Top