Can I lock a set of cells in a worksheet?

[puneetarora_12]

Hi,
Is it possible that a range of cells in a worksheet is protected from user editing, and the rest of the worksheet is editable as usual ?


Puneet Arora

[Max]

Try this sequence ..

Select the entire sheet first (press CTRL+A)
Click Format > Cells > Protection tab > Uncheck "Locked" > OK

Now select the range of cells to be protected, say B2:B10
Click Format > Cells > Protection tab > Check "Locked" > OK

Then apply sheet protection via:
Click Tools > Protection > Protect Sheet > Password? > OK

Check it out .. Only B2:B10 will be protected
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"puneetarora_12"
<[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> Is it possible that a range of cells in a worksheet is protected from
> user editing, and the rest of the worksheet is editable as usual ?
>
>
> Puneet Arora
>
>
> --
> puneetarora_12
> ------------------------------------------------------------------------
> puneetarora_12's Profile:
http://www.excelforum.com/member.php...o&userid=18406
> View this thread: http://www.excelforum.com/showthread...hreadid=385468
>

[puneetarora_12]

Works smooooth....

[Max]

"puneetarora_12" wrote:
>
> Works smooooth....

Glad to hear that !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----