Home

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

Red_Rock_It
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

Hi,

 

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?

 

Regards,

Haytham

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