can v lock column

[ilyaskazi]

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.

[mangesh_yadav]

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

[ilyaskazi]

mangesh, thanku once again

[mangesh_yadav]

Thanks for the feedback.

Mangesh

[Harald Staff]

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

HTH. Best wishes Harald

"ilyaskazi" <ilyaskazi.1q1mab_1117789527.3772@excelforum-nospam.com> skrev i
melding news:ilyaskazi.1q1mab_1117789527.3772@excelforum-nospam.com...
>
> 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
>

[Mike Fogleman]

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" <ilyaskazi.1q1mab_1117789527.3772@excelforum-nospam.com> wrote
in message news:ilyaskazi.1q1mab_1117789527.3772@excelforum-nospam.com...
>
> 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
>

[SathishKumar]

Hi all, I'm facing a similar problem...how to disable editing or protect only a specified column..
i'm getting error..
don know what to do..
help me pls

[Cutter]

Hello SathishKumar, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.