View Single Post
  #1   Report Post  
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!!!