Asp Forum - Locking certain cells.. - microsoft.public.excel.programming

DB

12/13/2006 11:09:00 PM

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 :)

6 Answers

Corey

12/13/2006 11:40:00 PM

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" <db002a3121@blueyonder.co.uk> wrote in message
news:uK%fh.15950$k74.2363@text.news.blueyonder.co.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 :)
>
>
>
>

DB

12/14/2006 12:01:00 AM

Many Thanks Corey...

Cheers

Dave :)

"Corey" <me@work.still> wrote in message
news:%2386jCAxHHHA.420@TK2MSFTNGP06.phx.gbl...
> 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" <db002a3121@blueyonder.co.uk> wrote in message
> news:uK%fh.15950$k74.2363@text.news.blueyonder.co.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 :)
>>
>>
>>
>>
>
>

DB

12/14/2006 12:05:00 AM

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" <db002a3121@blueyonder.co.uk> wrote in message
news:Iu0gh.15967$k74.9711@text.news.blueyonder.co.uk...
> Many Thanks Corey...
>
> Cheers
>
> Dave :)
>
>
> "Corey" <me@work.still> wrote in message
> news:%2386jCAxHHHA.420@TK2MSFTNGP06.phx.gbl...
>> 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" <db002a3121@blueyonder.co.uk> wrote in message
>> news:uK%fh.15950$k74.2363@text.news.blueyonder.co.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 :)
>>>
>>>
>>>
>>>
>>
>>
>
>

Corey

12/14/2006 12:12:00 AM

You need to remove ANY Ticks LOCKED for cells you want to be able to modify.
Select all cells you want to allow for modifying, and Format them as NO TICK
in the LOCKED BOX.

Corey....
"DB" <db002a3121@blueyonder.co.uk> wrote in message
news:Ty0gh.15974$k74.8288@text.news.blueyonder.co.uk...
> 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" <db002a3121@blueyonder.co.uk> wrote in message
> news:Iu0gh.15967$k74.9711@text.news.blueyonder.co.uk...
>> Many Thanks Corey...
>>
>> Cheers
>>
>> Dave :)
>>
>>
>> "Corey" <me@work.still> wrote in message
>> news:%2386jCAxHHHA.420@TK2MSFTNGP06.phx.gbl...
>>> 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" <db002a3121@blueyonder.co.uk> wrote in message
>>> news:uK%fh.15950$k74.2363@text.news.blueyonder.co.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 :)
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Corey

12/14/2006 12:19:00 AM

Tip,
If you have ONLY a Few Cells to be LOCKED or Protected and Much More to be
Unlocked or modifiable then do the following:

With Unproteced sheet.
Click on the small grey box in the top left corner of the sheet. (Between 1
& A)
This will select ALL cells in the sheet.
Then Click Format Cells - Protection - UnTick Locked. (May have to Click a
couple of times if sheded grey).

Then Select ALL Cells to be LOCKED. (Ctrl + Mouse Click)
Then Click Format Clees - Protection - Tick LOCKED while these cells are
selected.

Then Protect Sheet with/without P/W as required.

Hey Presto tis dones.

Corey....

"DB" <db002a3121@blueyonder.co.uk> wrote in message
news:Ty0gh.15974$k74.8288@text.news.blueyonder.co.uk...
> 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" <db002a3121@blueyonder.co.uk> wrote in message
> news:Iu0gh.15967$k74.9711@text.news.blueyonder.co.uk...
>> Many Thanks Corey...
>>
>> Cheers
>>
>> Dave :)
>>
>>
>> "Corey" <me@work.still> wrote in message
>> news:%2386jCAxHHHA.420@TK2MSFTNGP06.phx.gbl...
>>> 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" <db002a3121@blueyonder.co.uk> wrote in message
>>> news:uK%fh.15950$k74.2363@text.news.blueyonder.co.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 :)
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

DB

12/14/2006 1:05:00 AM

I think I must be missing something here.....Im following your steps and
then it still lets me type into the boxes I was trying to protect..

hmmm must be me......

Dave :))

it's late here so i'm off to kip - thanks for help and i'll report back
later.

:)

"Corey" <me@work.still> wrote in message
news:uAgUoVxHHHA.1044@TK2MSFTNGP02.phx.gbl...
> Tip,
> If you have ONLY a Few Cells to be LOCKED or Protected and Much More to be
> Unlocked or modifiable then do the following:
>
> With Unproteced sheet.
> Click on the small grey box in the top left corner of the sheet. (Between
> 1 & A)
> This will select ALL cells in the sheet.
> Then Click Format Cells - Protection - UnTick Locked. (May have to Click a
> couple of times if sheded grey).
>
> Then Select ALL Cells to be LOCKED. (Ctrl + Mouse Click)
> Then Click Format Clees - Protection - Tick LOCKED while these cells are
> selected.
>
> Then Protect Sheet with/without P/W as required.
>
> Hey Presto tis dones.
>
> Corey....
>
> "DB" <db002a3121@blueyonder.co.uk> wrote in message
> news:Ty0gh.15974$k74.8288@text.news.blueyonder.co.uk...
>> 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" <db002a3121@blueyonder.co.uk> wrote in message
>> news:Iu0gh.15967$k74.9711@text.news.blueyonder.co.uk...
>>> Many Thanks Corey...
>>>
>>> Cheers
>>>
>>> Dave :)
>>>
>>>
>>> "Corey" <me@work.still> wrote in message
>>> news:%2386jCAxHHHA.420@TK2MSFTNGP06.phx.gbl...
>>>> 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" <db002a3121@blueyonder.co.uk> wrote in message
>>>> news:uK%fh.15950$k74.2363@text.news.blueyonder.co.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 :)
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

microsoft.public.excel.programming

Locking certain cells..

DB

Corey

DB

DB

Corey

Corey

DB

x Login to ForumsZone