Tried it Corey.....but it says that it will have no effect unless I protect
the whole worksheet....but when i do this...I cant alter the data on the
left without unlocking everything.......hmmm sort of stuck,lol

Dave :))


"DB" wrote in message
. uk...
Many Thanks Corey...

Cheers

Dave :)


"Corey" wrote in message
...
Select ALL cells to be locked then:
Click on Format Cells - Select Protection - Tick the Locked Box.
Then Select OK.
Then :
Click Tools - Protection - Remove the Tick in the Select Locked Cells -
ADD a P/W - Verify P/W.
Then the users will not be able to select OR modify the cells you
selected and locked.

Corey....

"DB" wrote in message
. uk...
On my worksheet I have all my staff hours in detail on the left
side....the right side has the basics i.e. start and finish times...

Is there a way to lock the cells on the right from having anything
enterred on them.

At the moment, I input the details onto the left side and they are
duplicated onto certain cells on the right side.

Im trying to lock the right side so that people at work cant
accidentally overwrite the various important cells.


Thanks again....

Dave :)