ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to protect shapes in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/27555-how-protect-shapes-excel.html)

mslava123

How to protect shapes in Excel
 
Hello,
I have an Excel spreadsheet with different shapes on it ( check boxes,
option buttons, combo boxes ). Some of them should be protected from the
users. It means - if check box is checked then user should not be able to
uncheck it and the opposite. These shapes should be like 'Read-only' for the
user. I tried to protect the sheet with different options, but in any case
user is able to check or uncheck option buttons, check boxes etc. Protecting
of the sheet just doesn't let user to move the shape to different place.
Thank you.

mslava123

Never mind, I figured it out. Thanks.



All times are GMT +1. The time now is 07:06 PM.

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