Lock cells, but still be able to trace

[Johannes]

Dear all,

Is there someway to protect your worksheet cells, or at least the formula's
in it, but leave the rest open. One should not change the content (being the
formula), but should be able to do things like:
- Formatting of cell
- Formatting of row / column
- Hide column / row
- Use replace-functionality
-

Thanks,

Johannes

 

[Guest]

what is wrong with tools > protect sheet?

remember that you have to do cells > format > protection first to determine
which cells will be locked.

but if you just do tools > protection > protect sheet there are plenty of
options there for you to define what your users can and cannot change in the
locked cells.

 

[Johannes]

I think I did, but i can still not trace protected cells... can stil not
hide a row which contains protected cells...