Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i lock cells in exel | Setting up and Configuration of Excel | |||
Preserving lock on cells even when copied and pasted within a sheet | Excel Discussion (Misc queries) | |||
How To Lock Cells | Excel Discussion (Misc queries) | |||
Cannot set Excel to only lock specified cells | Excel Discussion (Misc queries) | |||
Lock cells without protecting sheet? | Excel Worksheet Functions |