R
ryguy7272
I am trying to figure out an easy way to scroll to the top of a sheet, when a
user clicks on the sheet. At first I thought something like this (below)
would work:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveSheet.Range("A1").Select...
...or...
Application.GoTo Sheets(1).Range("A1"), True
End Sub
I quickly realized that the Cell A1 is always selected whenever anything in
the sheet is clicked. I want to select Cell A1, or somehow scroll to the top
left of the sheet, when the sheet is clicked on for the first time, from
another sheet, but not each subsequent time the sheet is clicked on (as long
as the sheet has focus). How can this be done?
Thanks,
Ryan---
user clicks on the sheet. At first I thought something like this (below)
would work:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveSheet.Range("A1").Select...
...or...
Application.GoTo Sheets(1).Range("A1"), True
End Sub
I quickly realized that the Cell A1 is always selected whenever anything in
the sheet is clicked. I want to select Cell A1, or somehow scroll to the top
left of the sheet, when the sheet is clicked on for the first time, from
another sheet, but not each subsequent time the sheet is clicked on (as long
as the sheet has focus). How can this be done?
Thanks,
Ryan---