Lock a sheet without locking the labels

david1100

New Member
Joined
Apr 25, 2019
Messages
4
Good day all!

I have trouble protecting my sheet's data.
I would like to lock my sheet but keep the label alterable/unlock. I know how to do it for cells, but for the labels I can not do it.:mad:

While clicking on the protect sheet, there is no case for the labels to tick.

Thank you in advance for your help,
David.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,061
Office Version
365
Platform
Windows
Welcome to the forum

When protecting ...
- scroll to bottom and check the box "Edit Objects"

Does that achieve what you want?
 
Last edited:

david1100

New Member
Joined
Apr 25, 2019
Messages
4
Hello Yongle,

I have already tried but it does not work. When I go to the label manager, is it still grey and any modification are forbidden. :(
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,061
Office Version
365
Platform
Windows
Which version of Excel ?
Which label ? Active-X ? Form Control ?
 

david1100

New Member
Joined
Apr 25, 2019
Messages
4
I am using the last version, so the 2019.

It is the label in the fomulas->defined name->name manager. So I suppose I shoud call them "name" then :rolleyes:
I want to change their value even when the sheet is locked.
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,061
Office Version
365
Platform
Windows
It is the label in the fomulas->defined name->name manager. So I suppose I shoud call them "name" then
It is safer not make up your own label for anything Excel has already labelled otherwise we have no idea which label it is :rolleyes:

Re-phrased question : I would like to lock my sheet but keep Named Ranges editable
Answer : that is not possible

What can I do : Lift sheet protection first

If this is something you need to do on a regular basis consider using VBA to lift and re-apply protection
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,787
Messages
5,470,780
Members
406,720
Latest member
tylergaps

This Week's Hot Topics

Top