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!!!

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!!!
>

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!!!
> >

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!!!
> > >