HOW TO: If cell contains specific text that is part of a different list then return specific text

New Contributor

I'm using Excel 2016 and I have successfully locked all cells except for a few that need data entry.  My sheet contains several text boxes.  When I select all, and lock all cells, then manually unlock those few cells, the text boxes don't lock. I do NOT want anyone to be able to edit the text in those boxes.  If I right click on the box, go to Size and Properties, the Print Object, Locked and Lock Text boxes ARE checked, yet after protecting the sheet I can still edit the text in all text boxes.  Any ideas?  Thank you!

1 Reply



When you protect the worksheet, make sure that this option is unchecked:

Protect Sheet - Edit objects.png



But I think that the title of this post isn't related, right?




Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies