Forum Discussion

Zentao's avatar
Zentao
Copper Contributor
Oct 05, 2022

Can you lock some but not all objects in protected Excel sheet?

I am creating an excel worksheet which I want to protect except for various areas to be user-modified.  Some of the user entry areas are Cells and some are Text Boxes.  In order to allow the user to edit Text Boxes in a protected sheet I have to check 'Edit Objects' when protecting.  The issue, and the reason for my question, is I also have an image 'Company Logo' that I'd like to lock and prevent user modification, but images are considered objects along with the Text Boxes.  I am currently unable to lock the image but simultaneously allow editing of the Text Boxes.  Any suggestions?

excel

1 Reply

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Oct 06, 2022

    Hi Zentao 

     

    you could decide for every object if it is locked or not. By default, everything is locked.

     

    Just select the ones that should be editable, press Ctrl+1 to get the "Format Shape" area on the right side and then untick the "Locked" checkbox:

     

Resources