how to lock any specified column or row in excel or through vba??

I don't require any splitting / freezing panes.

If locked, user should not able to edit/delete any of the cells of
locked column or row.


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=376228

1. Select al cells, click Format Cells Protection tab and uncheck
the Locked tab.
2. Slecte the cells / columns / rows which you want to lock. Go to
Format Cells Protection tab and check the Locked tab.
3. Now go to Tools Protection Protect sheet. You may supply a
password if needed.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=376228

mangesh, thanku once agai

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=37622

Thanks for the feedback.

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37622

Sub Test()
With Sheets(2)
..Cells.Locked = False
..Columns("C:C").Locked = True
..Protect
End With
End Sub

HTH. Best wishes Harald

"ilyaskazi" skrev i
melding ...

how to lock any specified column or row in excel or through vba??

I don't require any splitting / freezing panes.

If locked, user should not able to edit/delete any of the cells of
locked column or row.


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=376228

Add rows to Haralds code:

Sub Test()
With Sheets(2)
..Cells.Locked = False
..Columns("C:C").Locked = True
..Rows(2:6).Locked = True
..Protect
End With
End Sub

MIke F

"ilyaskazi" wrote
in message ...

how to lock any specified column or row in excel or through vba??

I don't require any splitting / freezing panes.

If locked, user should not able to edit/delete any of the cells of
locked column or row.


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=376228