ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I have lock a wookbook but one cell does not want to lock it (https://www.excelbanter.com/excel-discussion-misc-queries/126981-i-have-lock-wookbook-but-one-cell-does-not-want-lock.html)

Mimi

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

Mimi

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


ShaneDevenshire

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