H
hansjuh
Currently I am working on a large worksheet. I am working on the fina
stage in which i want to protect it.
My sheet is completely colorcoded. There are about 1000 cells with
white background which the user may edit. All other cells (also man
more than 1000) must be locked.
I now have locked all cells. But I am not very fond of unlocking over
1000 cells by hand. Is there a piece of code to automate this?
something like:
if cell background = white
than cell = unlocked
else cell = locke
stage in which i want to protect it.
My sheet is completely colorcoded. There are about 1000 cells with
white background which the user may edit. All other cells (also man
more than 1000) must be locked.
I now have locked all cells. But I am not very fond of unlocking over
1000 cells by hand. Is there a piece of code to automate this?
something like:
if cell background = white
than cell = unlocked
else cell = locke