Locked Cell - can still edit
 

Good morning all,

i have a workbook whhere i want to lock most of the cells.

Have selected all cells in the sheet, gone format protection select
locked, then tools protection protect sheet.

the majority of cells i cannot edit, but there are some where i can
still edit. (FYI the cells i can edit were inserted previously)

Driving me crazy

Phil (Excel user of 7 years dazed by a simple protection problem ¦-(
)

BTW Excel XP

Locked Cell - can still edit
 

press ctl+a.
you will see that sheet has been selected.
got to the format,cell,protaction,uncheked the locked.press ok.
now select the cell which u want to lock more than one press ctrl+right
click and than once again repeat the above procedure. now u have to check the
locked cell.
protect the sheet.
note: locked cell will work only on protect sheet


"philcud" wrote:

Good morning all,

i have a workbook whhere i want to lock most of the cells.

Have selected all cells in the sheet, gone format protection select
locked, then tools protection protect sheet.

the majority of cells i cannot edit, but there are some where i can
still edit. (FYI the cells i can edit were inserted previously)

Driving me crazy

Phil (Excel user of 7 years dazed by a simple protection problem ¦-(
)

BTW Excel XP

Locked Cell - can still edit
 

gone ctrl A, unlocked all cells, ok. again selected whole sheet, locked
cells, protected sheet. still some cells i can edit!!
WHY???

hitesh wrote:
press ctl+a.
you will see that sheet has been selected.
got to the format,cell,protaction,uncheked the locked.press ok.
now select the cell which u want to lock more than one press ctrl+right
click and than once again repeat the above procedure. now u have to check the
locked cell.
protect the sheet.
note: locked cell will work only on protect sheet


"philcud" wrote:

Good morning all,

i have a workbook whhere i want to lock most of the cells.

Have selected all cells in the sheet, gone format protection select
locked, then tools protection protect sheet.

the majority of cells i cannot edit, but there are some where i can
still edit. (FYI the cells i can edit were inserted previously)

Driving me crazy

Phil (Excel user of 7 years dazed by a simple protection problem ¦-(
)

BTW Excel XP