Unlock cells without values

[Piotr]

Hi
I do many files where I have to lock the cells for users,
Is there any way to make excell unlock every cell that is empty and
lock every cell which contains data or formulas in ?

regards
Piotr

 

[yogendra.joshi]

Press F5 (Edit ->Go to) -> Special -> Blanks

Now, without changing the selection, unlock cells.

Note: This will select only those empty cells in the "used range".

If you want to unlock ALL the blank cells in the sheet, then, first
select all, unlock
then using the go to special, select formulae & constants and lock them

Hope this helps

~Yogendra