Chris Pfeiffer
asked on
Worksheet Focus from hyperlink
I want to click on a hyperlink and make it so the sheet it goes to focuses on a specific cell, then I want the cell to be located in the upper left corner of the screen. So I have the Hyperlink to a specific cell done, I just dont know how to get the sheet to move up, down, left, right to make the focus point I want.
Any help?
Any help?
ASKER
Well right now what I am doing is moving the work sheet to the desired location, then selecting the cell in the bottom right corner of the sheet as the location for my hyperlink to focus on. The only problem is this will only work for people using the same display setup as me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use this macro if you are linking from the same sheet
Private Sub Worksheet_FollowHyperlink( ByVal Target As Hyperlink)
ActiveWindow.ScrollRow = ActiveCell.Row
ActiveWindow.ScrollColumn = ActiveCell.Column
End Sub
Regards,
Curt
Private Sub Worksheet_FollowHyperlink(
ActiveWindow.ScrollRow = ActiveCell.Row
ActiveWindow.ScrollColumn = ActiveCell.Column
End Sub
Regards,
Curt
ASKER
Thank you very much!
http://excel.tips.net/Pages/T002479_Adding_Buttons_to_Your_Worksheet.html
Michael