Can I lock a set of cells in a worksheet?
 

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

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 <atyahoo<dotcom
----
"puneetarora_12"
<puneetarora_12.1rtw6m_1120788316.3514@excelforu m-nospam.com wrote in
message news:puneetarora_12.1rtw6m_1120788316.3514@excelfo rum-nospam.com...

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

:)

Works smooooth....


--
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" wrote:
:)
Works smooooth....

Glad to hear that !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----