Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I cannot get the lock specific cell function below to work:
1. Select entire worksheet by clicking the Select All button 2. Click Cells on the format menu, click the Protection Tab, and clear the LOCKED check box. 3. Select the cells you want to lock and repeat step 2, but this time select the LOCKED check box. 4. Go to tools menu, point to Protection, and click Protect Sheet. Then OK. It locks the entire worksheet instead of the few cells I've locked individually. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
Protect/Lock Specific Cells | Excel Discussion (Misc queries) |