![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com