Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protect cell formulae
Is it possible to prevent a cell from being written in? I want it to show
the results of data written elsewhere. |
#2
|
|||
|
|||
Protect cell formulae
Hi Harry
By default,all cells in a worksheet are protected, but that does not become operative until you invoke ToolsProtectionProtect Sheet either with or without password. If you want any cells on the sheet to allow data entry, then you have to first FormatCellsProtection and remove the protection mark before invoking protection for the Sheet. Regards Roger Govier Harry Limey wrote: Is it possible to prevent a cell from being written in? I want it to show the results of data written elsewhere. |
#3
|
|||
|
|||
Protect cell formulae
Hi Harry
By default,all cells in a worksheet are protected, but that does not become operative until you invoke ToolsProtectionProtect Sheet either with or without password. If you want any cells on the sheet to allow data entry, then you have to first FormatCellsProtection and remove the protection mark before invoking protection for the Sheet. Regards Roger Govier Harry Limey wrote: Is it possible to prevent a cell from being written in? I want it to show the results of data written elsewhere. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
I need to protect all but one cell in an Excel XP spreadsheet. | Excel Discussion (Misc queries) | |||
Protect Cell Formatting | Excel Worksheet Functions | |||
protect cell | Excel Worksheet Functions | |||
How do I protect one cell in a spreadsheet? | Excel Worksheet Functions |