| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i lock a cell with a fromula?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i lock a cell with a fromula?
By default all cells on a sheet are locked when the sheet is protected.
CTRL + a(twice in 2003) to select all cells. FormatCellsProtection. Uncheck "locked" and OK Now select the sections/rows/cells to protect and FormatCellsProtection. Check "locked" and OK ToolsProtectionProtect Sheet The section/row locking does not work if you don't protect the sheet. Gord Dibben MS Excel MVP On Tue, 8 Aug 2006 12:47:02 -0700, Elin wrote: Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
