Forum Discussion
Zentao
Oct 05, 2022Copper Contributor
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 ...
Martin_Weiss
Oct 06, 2022Bronze Contributor
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: