ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reversing from a Hyper link (https://www.excelbanter.com/excel-programming/431146-reversing-hyper-link.html)

Jackflash21

Reversing from a Hyper link
 
I am working on a fairly complex work book and it requires over 100 tabs.

The issue is when I make the jump via a hyperlink to a central information
sheet and want to get back to the tab I came from.

Any ideas how to make a "Back" button, so I can simply go back to the tab
where I came from?

ryguy7272

Reversing from a Hyper link
 
Can't you just place another hyperlink in there that references the sheet
that you came from?

Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jackflash21" wrote:

I am working on a fairly complex work book and it requires over 100 tabs.

The issue is when I make the jump via a hyperlink to a central information
sheet and want to get back to the tab I came from.

Any ideas how to make a "Back" button, so I can simply go back to the tab
where I came from?


EricG

Reversing from a Hyper link
 
That will work, but before making the jump to the master sheet, reset the
pointer for the "Return to Last Worksheet" hyperlink to the current
worksheet. That way it will always point to the last tab you were on before
going to the master.

Eric

"ryguy7272" wrote:

Can't you just place another hyperlink in there that references the sheet
that you came from?

Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jackflash21" wrote:

I am working on a fairly complex work book and it requires over 100 tabs.

The issue is when I make the jump via a hyperlink to a central information
sheet and want to get back to the tab I came from.

Any ideas how to make a "Back" button, so I can simply go back to the tab
where I came from?



All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com