Link to home
Start Free TrialLog in
Avatar of Chris Pfeiffer
Chris PfeifferFlag for Japan

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?
Avatar of Michael Fowler
Michael Fowler
Flag of Australia image

I am not aware if this can be done using a hyperlink but you could use a button and have a macro to simply select the cell in question
http://excel.tips.net/Pages/T002479_Adding_Buttons_to_Your_Worksheet.html

Michael
Avatar of Chris Pfeiffer

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
Avatar of Curt Lindstrom
Curt Lindstrom
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Thank you very much!