Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 26th 05, 08:55 PM
marika1981
 
Posts: n/a
Default Intra-workbook hyperlink: macro/function to return to hyperlink ce

I'm creating a workbook to be used by non-Excel users. It includes a number
of worksheets and uses hyperlinks between certain data and a worksheet of
corresponding footnotes at the end of the workbook.

I've used hyperlinks to direct users to the footnotes easily, but I can't
find a function that aids the user in going back to the cell and tab in which
the user clicked the hyperlink - any ideas?

Ideally I'd like to create a macro button at the top of the footnote page
that "returns to previous cell", regardless of which footnote was viewed. (I
realize I could create separate macros linking each footnote back to its
specific hyperlink, but I'm really only interested in a "universal"
go-back-one-step-type function)

Any thoughts would be very much appreciated!!!!

Thank YOU!!!


  #2   Report Post  
Old May 5th 05, 08:04 AM
BarryL
 
Posts: n/a
Default

marika...

I am trying to do the same sort of thing with similar lack of success. It
has been a while since you posted. I'd be interested in hearing how you
accomplished this.

BarryL

"marika1981" wrote:

I'm creating a workbook to be used by non-Excel users. It includes a number
of worksheets and uses hyperlinks between certain data and a worksheet of
corresponding footnotes at the end of the workbook.

I've used hyperlinks to direct users to the footnotes easily, but I can't
find a function that aids the user in going back to the cell and tab in which
the user clicked the hyperlink - any ideas?

Ideally I'd like to create a macro button at the top of the footnote page
that "returns to previous cell", regardless of which footnote was viewed. (I
realize I could create separate macros linking each footnote back to its
specific hyperlink, but I'm really only interested in a "universal"
go-back-one-step-type function)

Any thoughts would be very much appreciated!!!!

Thank YOU!!!

  #3   Report Post  
Old May 5th 05, 01:42 PM
marika1981
 
Posts: n/a
Default

Barry - I'm running out the door right now but will write tonight. I found a
solution that worked perfectly and easily, however it will take a while for
me to explain Hope you can wait til then

Marika


"BarryL" wrote:

marika...

I am trying to do the same sort of thing with similar lack of success. It
has been a while since you posted. I'd be interested in hearing how you
accomplished this.

BarryL

"marika1981" wrote:

I'm creating a workbook to be used by non-Excel users. It includes a number
of worksheets and uses hyperlinks between certain data and a worksheet of
corresponding footnotes at the end of the workbook.

I've used hyperlinks to direct users to the footnotes easily, but I can't
find a function that aids the user in going back to the cell and tab in which
the user clicked the hyperlink - any ideas?

Ideally I'd like to create a macro button at the top of the footnote page
that "returns to previous cell", regardless of which footnote was viewed. (I
realize I could create separate macros linking each footnote back to its
specific hyperlink, but I'm really only interested in a "universal"
go-back-one-step-type function)

Any thoughts would be very much appreciated!!!!

Thank YOU!!!

  #4   Report Post  
Old May 6th 05, 05:47 AM
BarryL
 
Posts: n/a
Default

Marika1981-I found a "sort of solution" using hyperlinks to the source page
where I have a series of layouts that I want to copy, then manually using the
"alt left arrow" to return to the target page where I want to insert the
layouts. However, I am still struggling with a macro or code to do the same
thing.

"marika1981" wrote:

Barry - I'm running out the door right now but will write tonight. I found a
solution that worked perfectly and easily, however it will take a while for
me to explain Hope you can wait til then

Marika


"BarryL" wrote:

marika...

I am trying to do the same sort of thing with similar lack of success. It
has been a while since you posted. I'd be interested in hearing how you
accomplished this.

BarryL

"marika1981" wrote:

I'm creating a workbook to be used by non-Excel users. It includes a number
of worksheets and uses hyperlinks between certain data and a worksheet of
corresponding footnotes at the end of the workbook.

I've used hyperlinks to direct users to the footnotes easily, but I can't
find a function that aids the user in going back to the cell and tab in which
the user clicked the hyperlink - any ideas?

Ideally I'd like to create a macro button at the top of the footnote page
that "returns to previous cell", regardless of which footnote was viewed. (I
realize I could create separate macros linking each footnote back to its
specific hyperlink, but I'm really only interested in a "universal"
go-back-one-step-type function)

Any thoughts would be very much appreciated!!!!

Thank YOU!!!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink to specific sheet; workbook saved as html Bawn Excel Worksheet Functions 0 January 5th 05 02:31 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017