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
Problems with formating text within a cell.
Maciej Fox in Excel on
10 Replies
2 lists, 1 if
Bartosz Heller in Excel on
4 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies