M M-Hero Oct 22, 2003 #1 Would anyone happen to know how to protect a specific column? I know how to protect Workbook and Worksheet, but Column.
Would anyone happen to know how to protect a specific column? I know how to protect Workbook and Worksheet, but Column.
M M-Hero Oct 22, 2003 #2 I figured out how to protect specific columns already; Check this out. Sub Lock_Columns() 'To lock specific columns
I figured out how to protect specific columns already; Check this out. Sub Lock_Columns() 'To lock specific columns
M M-Hero Oct 22, 2003 #3 To lock specific columns; check this out. Sub lock_columns() Cells.Select Selection.Locked = False Selection.FormulaHidden = False Columns("B:C").Select Selection.Locked = True Selection.FormulaHidden = False ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub
To lock specific columns; check this out. Sub lock_columns() Cells.Select Selection.Locked = False Selection.FormulaHidden = False Columns("B:C").Select Selection.Locked = True Selection.FormulaHidden = False ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub
