Many thanks to all. Before I used to protect the cells by using Data
Validation and I didn't know that there is an easy way to do that. Thanks
again.

SRM

"Casey" <Casey.1tmh6e_1123801509.9345@excelforum-nospam.com> wrote in
message news:Casey.1tmh6e_1123801509.9345@excelforum-nospam.com...
>
> SRM,
> Locking cells is a two step process.
> Go to FORMAT>CELLS and then go to the Protection tab and for each range
> of cells you want protected or locked make sure the "Locked" option is
> checked. Conversely, for every group of cells you want to be able to
> change make sure the "Locked" option is unchecked.
>
> Now, none of this locks or unlocks anything until you go to
> TOOLS>PROTECTION>PROTECT SHEET. After you protect the sheet all cells
> which have the "Locked" option checked will be unalterable and those
> that have the "Locked" option unchecked will be alterable.
>
> There is a good deal more to learn about the many options with locking
> and unlocking and I would direct you to the Excel help file.
>
>
>
> Hope this helps
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile:
> http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=395137
>