VBA Code to Open Hyperlinks (in order please!)

[mdacosta]

Hi everyone,

I'm a total rookie, but I would like to make a hotkey that opens (follows) 3 hyperlinks in order depending on what row I'm currently on. We'll call the hyperlink names AAA, BBB, CCC that are located at J#, K#, and L# respectively. The reason I have # attached is because I have a LOT of rows that I need to be opened (when I am currently on that row). I essentially have to open 3 hyperlinks to gather my data. Then (last step) if I could have the page switch to, let's say, tab ZZZ in the workbook. If anyone could help me out I would be very grateful!!!!

[Toonies]

Hi this may help you

http://office.microsoft.com/en-gb/ex...005199516.aspx

[mdacosta]

Awesome, I am not in the office ATM, but I will definitely check it out first thing Monday morning! Appreciate the help!