A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple links across worksheets - displayed format



 
 
Thread Tools Display Modes
  #1  
Old September 7th, 2004, 09:41 PM
Alex
external usenet poster
 
Posts: n/a
Default 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  
Old September 8th, 2004, 12:57 AM
Bill Manville
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 09:36 PM
find on multiple worksheets fnfuser Worksheet Functions 2 January 30th, 2004 11:26 PM


All times are GMT +1. The time now is 01:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.