Lock cells, but still be able to trace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johannes - 25 Oct 2006 15:21 GMT

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

Reply to this Message

Allllen - 25 Oct 2006 18:08 GMT

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.

Signature

Allllen

> Dear all,
>
[quoted text clipped - 10 lines]
>
> Johannes

Reply to this Message

Johannes - 27 Oct 2006 10:19 GMT

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

> what is wrong with tools > protect sheet?
>
[quoted text clipped - 23 lines]
>>
>> Johannes

Reply to this Message