G
GPO
Try this:
In a clean worksheet, select a range of cells (say C3 to F6).
Go to format > cells > protection, and uncheck locked.
Now to to tools > protection > protect sheet, and check [Protect worksheet
and contects of locked cells]
In [Allow all users of this worksheet to:] Make sure only [Select unlocked
cells] is checked.
Click OK
Now select edit > clear all.
Excel has taken the liberty of changing all you unlocked cells to locked.
How can I stop this happening? I have locked and unlocked cells on my sheet
for a reason and this feature is a real nuisance. Is it possible to allow
people to change to contents of the unlocked cells but nothing else about the
cells?
Any advice greatly appreciated (Ideally I'd want something that works on any
Excel from 2000 on).
Regard
GPO
In a clean worksheet, select a range of cells (say C3 to F6).
Go to format > cells > protection, and uncheck locked.
Now to to tools > protection > protect sheet, and check [Protect worksheet
and contects of locked cells]
In [Allow all users of this worksheet to:] Make sure only [Select unlocked
cells] is checked.
Click OK
Now select edit > clear all.
Excel has taken the liberty of changing all you unlocked cells to locked.
How can I stop this happening? I have locked and unlocked cells on my sheet
for a reason and this feature is a real nuisance. Is it possible to allow
people to change to contents of the unlocked cells but nothing else about the
cells?
Any advice greatly appreciated (Ideally I'd want something that works on any
Excel from 2000 on).
Regard
GPO