Dynamic Hyperlinks
 

I have a workbook with 40 some sheets.
1 is a summary sheet and the others are the detail. Some detail sheets have more than one piece of information.
Each row on the summary sheet has hyperlink that the user can click to see the detail. Presently, to go back to the summary sheet there is a hyperlink that takes the user back to cell A1 of the summary sheet.

I would like the user to be able to click the hyperlink and go back to the row in the summary sheet he came from.

I thought I could set up a sub routine in the summary sheet's coding, but click isn't one of the optinos.

Please help

Dynamic Hyperlinks
 

Hi Richard,

Am Thu, 12 Nov 2015 13:35:51 -0800 (PST) schrieb :

I have a workbook with 40 some sheets.
1 is a summary sheet and the others are the detail. Some detail sheets have more than one piece of information.
Each row on the summary sheet has hyperlink that the user can click to see the detail. Presently, to go back to the summary sheet there is a hyperlink that takes the user back to cell A1 of the summary sheet.

in which range in Summary are the hyperlinks and in which cell in the
detail sheets is the hyperlink?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Dynamic Hyperlinks
 

On Friday, November 13, 2015 at 2:25:25 AM UTC-8, Claus Busch wrote:
Hi Richard,

Am Thu, 12 Nov 2015 13:35:51 -0800 (PST) schrieb :

I have a workbook with 40 some sheets.
1 is a summary sheet and the others are the detail. Some detail sheets have more than one piece of information.
Each row on the summary sheet has hyperlink that the user can click to see the detail. Presently, to go back to the summary sheet there is a hyperlink that takes the user back to cell A1 of the summary sheet.

in which range in Summary are the hyperlinks and in which cell in the
detail sheets is the hyperlink?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

In summary, all the hyper links -- there are some 200 of them -- are in column B, the "return" hyperlink on each detail sheet is in J1

Dynamic Hyperlinks
 

Hi,

Am Sat, 14 Nov 2015 09:45:29 -0800 (PST) schrieb :

In summary, all the hyper links -- there are some 200 of them -- are in column B, the "return" hyperlink on each detail sheet is in J1

sheets "Summary" is the first sheet and the hyperlinks start in B1 or
you have to modify the code as expected:

Sub Hyp()
Dim n As Long

Application.ScreenUpdating = False
For n = 2 To Sheets.Count
With Sheets(n)
Application.Goto .Range("J1")
.Hyperlinks.Add _
anchor:=ActiveCell, _
Address:="", _
SubAddress:="'Summary'!" & Range("B" & n - 1).Address
End With
Next
Application.ScreenUpdating = True
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional