Dear Excel Expert,
Is there any way where I can used my macro-enabled sheet while locking certain cells in my excel sheet?
Attached is part of my macro VBA code, thanks for your advise!
Sub Apr()
'
' Apr Macro
'
'
ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="April"
End Sub
Sub Mar()
'
' Mar Macro
'
'
ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="Mar"
ActiveWindow.SmallScroll Down:=-108
Range("C219").Select
End Sub
Sub Feb()
'
' Feb Macro
'
'
ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="Feb"
ActiveWindow.SmallScroll Down:=-30
End Sub
Sub Jan()
'
' Jan Macro
'
'
ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="Jan"
ActiveWindow.SmallScroll Down:=-18
End Sub
Bookmarks