How to protect shapes in Excel

G

Guest

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.
 

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