If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple links across worksheets - displayed format
Hopefully I can get the question clearly across.
I have a workbook with two worksheets. One displays projects and the other displays resources. On each worksheet the first viewable 30 or so rows gives a summary, projects and resources. Now below each summary I have a detail of each project and what resources are working on it, as well as each resource and what projects they are on. Are you still with me? Now everywhere there is a project or resource listed I have a link to that corresponding section on either worksheet. The problem I am having is when I jump between worksheets. When I click a link it goes to the link but then I have to scroll down to get the full view of the data related. Logically I understand why it would do this but I'm wondering if there is a easy fix, before I mess around with 100+ links? Is it just a matter of redirecting the link so that "aim" lower in the range of data? -- Jack of all trades... master of none.. |
#2
|
|||
|
|||
Alex wrote:
The problem I am having is when I jump between worksheets. When I click a link it goes to the link but then I have to scroll down to get the full view of the data related. In the ThisWorkbook module add a Workbook_SheetFollowHyperlink procedure Private Sub Workbook_SheetFollowHyperlink(ByVal Sg As Object, ByVal Target As Hyperlink) ActiveWindow.ScrollColumn = ActiveCell.Column ActiveWindow.ScrollRow = ActiveCell.Row End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge data from multiple worksheets | colby | General Discussion | 2 | August 17th, 2004 02:20 AM |
Still having Web Page Pathing Problems / Relative Links show Netwo | webmaster | Powerpoint | 27 | July 15th, 2004 11:16 PM |
Setting paper source for multiple worksheets | Randy | Worksheet Functions | 2 | February 18th, 2004 08:36 PM |
find on multiple worksheets | fnfuser | Worksheet Functions | 2 | January 30th, 2004 10:26 PM |