ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet Object Protection (https://www.excelbanter.com/excel-programming/415363-worksheet-object-protection.html)

Christmas May[_2_]

Worksheet Object Protection
 
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


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com