Lock cells, but still be able to trace
 

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

Lock cells, but still be able to trace
 

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.

--
Allllen


"Johannes" wrote:

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

Lock cells, but still be able to trace
 

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


"Allllen" schreef in bericht
...
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.

--
Allllen


"Johannes" wrote:

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