I have a excel hyperlink that is generated by code and i want to be able to click the link with vba or a macro and follow it. I have tried recording a macro but it follows to a specific cell and as the hyperlink address keeps changing this doesn't work
Thanks for the reply but the link i want to click points to an excel cell on another worksheet that i want to go to and using your code results in hi-lighted error in vba code module
You may find it necessary to specify additional qualifiers, such as the worksheet name in this line:
Worksheets("Sheet1").Range("A1").Hyperlinks(1).Follow
This may take some experimentation with the Follow method of the Hyperlink object.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!