Hi Experts:

Plese advise that how can i protect a single row or column through any
functon or macro.

thanks in advance
khalil

By default, all cells in a worksheet are "protected" when you click on TOOLS
PROTECTION and activate protection on the sheet or the workbook.

But if you highlight all the cells you want to still be able to edit when
the sheet is protected and got to FORMAT CELLS PROTECTION and uncheck the
protection box, protecting the sheet won't affect these cells.

So this is the opposite of what you asked. This is how you set certain cells
to STILL be editable when you've locked your sheet. But it gives you what you
need. The column you want to stay protected, leave the protection flag on for
that column, then protect the sheet.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Khalil" wrote:

Hi Experts:

Plese advise that how can i protect a single row or column through any
functon or macro.

thanks in advance
khalil

Hi,

As your other respondent has pointed out by default all cells are locked
but this only becomes 'active' when the sheet is protected so you would start
by selecting all cells then

Format|Cells - Protection tab and remove the locked checkmark

This macro then activates 'Locked' for a row of your choosing

Sub Prime_Lending()
ActiveSheet.Unprotect Password:="MyPass"
Rows("1:1").Locked = True
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike

"Khalil" wrote:

Hi Experts:

Plese advise that how can i protect a single row or column through any
functon or macro.

thanks in advance
khalil

me no expert but share with you what I know

try :
1) Highlight the whole sheet
2) Select Cell under Format in the menu bar
3) Go to Protection tab
4) uncheck Locked, click OK
5) Select or highlight the row or column you want to protect
6) Go Cell under Format again
7) Go to Protection tab and check the Locked, click OK
8) Protect the sheet via Tool Protection

--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis










"Khalil" wrote:

Hi Experts:

Plese advise that how can i protect a single row or column through any
functon or macro.

thanks in advance
khalil