Solved

Worksheet Focus from hyperlink

Posted on 2011-02-16
5
344 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:Chrispy2811
  • 2
  • 2
5 Comments
 
LVL 23

Expert Comment

by:Michael74
Comment Utility
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
0
 
LVL 2

Author Comment

by:Chrispy2811
Comment Utility
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.
0
 
LVL 18

Accepted Solution

by:
Curt Lindstrom earned 500 total points
Comment Utility
Try this macro as a sheet macro in the sheet you are linking to if you are linking from a another sheet

Private Sub Worksheet_Activate()
    ActiveWindow.ScrollRow = ActiveCell.Row
    ActiveWindow.ScrollColumn = ActiveCell.Column
End Sub

Regards,
Curt
0
 
LVL 18

Expert Comment

by:Curt Lindstrom
Comment Utility
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
0
 
LVL 2

Author Closing Comment

by:Chrispy2811
Comment Utility
Thank you very much!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now