simora
10-10-2014, 09:25 PM
I'm trying to lock specific rows when a worksheet opens.
This is the code that I have which is NOT working.
Its selecting the rows, but, thats it.
What am I doing wrong?
Worksheets(MySht).Activate
Rows(3).Select
Selection.Locked = True
Selection.FormulaHidden = False
Rows(8).Select
Selection.Locked = True
Selection.FormulaHidden = False
This is the code that I have which is NOT working.
Its selecting the rows, but, thats it.
What am I doing wrong?
Worksheets(MySht).Activate
Rows(3).Select
Selection.Locked = True
Selection.FormulaHidden = False
Rows(8).Select
Selection.Locked = True
Selection.FormulaHidden = False