s.schwantes
01-09-2015, 07:09 PM
I have multiple Form Control buttons used to navigate to other locations on a ws which would otherwise require a lot of scrolling and/or paging up/down.
At the top section I have several buttons labeled Go To and then in the target areas I have buttons labeled Go Home to return to range "A1".
Here's the code from one of the buttons:
Sub GoTo_IncomeStmtConsol()
Application.ScreenUpdating = True
Application.Goto Reference:="Income_Stmt_Consol"
ActiveWindow.SmallScroll Down:=30
ActiveWindow.FreezePanes = True
End Sub
What I don't understand is sometimes this works just fine. The macro runs, goes to the designated named range, which in this case is "Income_Stmt_Consol" which also happens to be cell C91 ... and the panes freeze around the range with both vertical and horizontal panes as you'd expect w/ C91 in the top left corner. However, at the moment it's just locking panes horizontally at row 109.
Puzzling.
Any one have an explanation or solution to this problem - which does seem to be intermittent.
Thanks!!
Steve
At the top section I have several buttons labeled Go To and then in the target areas I have buttons labeled Go Home to return to range "A1".
Here's the code from one of the buttons:
Sub GoTo_IncomeStmtConsol()
Application.ScreenUpdating = True
Application.Goto Reference:="Income_Stmt_Consol"
ActiveWindow.SmallScroll Down:=30
ActiveWindow.FreezePanes = True
End Sub
What I don't understand is sometimes this works just fine. The macro runs, goes to the designated named range, which in this case is "Income_Stmt_Consol" which also happens to be cell C91 ... and the panes freeze around the range with both vertical and horizontal panes as you'd expect w/ C91 in the top left corner. However, at the moment it's just locking panes horizontally at row 109.
Puzzling.
Any one have an explanation or solution to this problem - which does seem to be intermittent.
Thanks!!
Steve