How to make multiple Hyperlinks in a CURRENT page in VisualB

DetroitDr

New Member
Joined
Sep 27, 2006
Messages
9
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.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
L

Legacy 98055

Guest
Dr. Please post the code that you have recorded. I am supposing that this code is to perform the exact same operation for each worksheet?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,037
Messages
5,545,665
Members
410,697
Latest member
srishtijain0708
Top