| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have lock a wookbook but one cell does not want to lock it
I have locked all I need to be locked in my workbook except for one cell that
does not let me look which is the # of invoice and I wanted look how do I do this please let me know fat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have lock a wookbook but one cell does not want to lock it
sorry instead of look Its LOCK mistake jajjaj
"mimi" wrote: I have locked all I need to be locked in my workbook except for one cell that does not let me look which is the # of invoice and I wanted look how do I do this please let me know fat |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I have lock a wookbook but one cell does not want to lock it
Hi,
Here is the answer to what I think you are asking: 1. Select the cell or cells you don't want locked. 2. Choose the command Format, Cells, Protection, and uncheck Locked. Click OK. 3. Choose the command Tools, Protection, Protect Sheet 4. Add a password or not and click OK. -- Cheers, Shane Devenshire "mimi" wrote: sorry instead of look Its LOCK mistake jajjaj "mimi" wrote: I have locked all I need to be locked in my workbook except for one cell that does not let me look which is the # of invoice and I wanted look how do I do this please let me know fat |
| 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 | |||
Linear Mode
