can v lock column

  • Thread starter Thread starter ilyaskazi
  • Start date Start date
I

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.
 
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
 
Sub Test()
With Sheets(2)
..Cells.Locked = False
..Columns("C:C").Locked = True
..Protect
End With
End Sub

HTH. Best wishes Harald
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking specific cells 1
VBA to lock column values 1
Need help with locking columns 4
Conditional Cell Lock 2
form buttons on sheet collapse on unhide - sometimes 5
multiple value choices for If range().value = "xxx" 1
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2
vba to lock columns b thru d based on value selected in col a 1

Back
Top