Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lock a cell
how can I lock a cell in a form that nobody can change it?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lock a cell
Select the entire sheet and right click, select format cells, select the
protection tab, remove the tick in the 'LOCKED' block and press ok. Now select the cell/cells you want to protect and right click again, select format cells, select the protection tab, add the tick in the 'LOCKED' block and press ok. Now go to tools and select protect sheet (you can password protect it, but I usually leave the pass word blank, it's less to remember), only those cells with the tick in the "LOCKED' block will be locked from being modified. If you want to unlock the sheet, go to tool select unlock sheet and select OK (or enter in the password if you have used one) "Kameron" wrote: how can I lock a cell in a form that nobody can change it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |