Hello,
I have a workbook with 201 pages.
Page 1 is a "template with data"
The rest are copied pages.
What I'm trying to do is for a current page create multiple hyperlinks that go elsewhere on the same page. Eg Hyperlink E5 to jump to E20 (on the same page)
Issue: From my lack of experience when I try to automate it using a macro, it creates the link to the origonal page I recorded the macro on. So If I was on page 2 and recorded all my hyperlinks, ran the macro on page 3 then all the follow throughs are to page 2 on page 3.
So I can only guess I need to VBscript it with some kind of CURRENT PAGE hyperlink command.
Help anyone?
Thank-you in advance.
I have a workbook with 201 pages.
Page 1 is a "template with data"
The rest are copied pages.
What I'm trying to do is for a current page create multiple hyperlinks that go elsewhere on the same page. Eg Hyperlink E5 to jump to E20 (on the same page)
Issue: From my lack of experience when I try to automate it using a macro, it creates the link to the origonal page I recorded the macro on. So If I was on page 2 and recorded all my hyperlinks, ran the macro on page 3 then all the follow throughs are to page 2 on page 3.
So I can only guess I need to VBscript it with some kind of CURRENT PAGE hyperlink command.
Help anyone?
Thank-you in advance.
