Forum Discussion
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 ...
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: