Locked Cell - can still edit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

philcud - 27 Oct 2006 10:41 GMT

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

Reply to this Message

hitesh - 27 Oct 2006 14:31 GMT

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

> Good morning all,
>
[quoted text clipped - 12 lines]
>
> BTW Excel XP

Reply to this Message

philcud - 27 Oct 2006 16:28 GMT

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

> press ctl+a.
> you will see that sheet has been selected.
[quoted text clipped - 21 lines]
> >
> > BTW Excel XP

Reply to this Message