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