Hey guys/gals!
So as the title indicates, I don't know how to do this. I know how to make hyperlinks with VBA, but not on all visible pages.
Additionally, I was hoping to make every hyperlink retain whatever text is already in cell A2.
Here's why I'm doing it: I want to have people be able to navigate from my TOC's hyperlinks (which I've already created) to each worksheet, but also navigate back to the TOC via hyperlink. The reason why I want to keep the cell text is because I want to hide the link behind the title for the page (cell A2), as I don't want to rely on my team remembering to hide the link when it's time to put our client presentation into PDF.
If anyone can help me, I would greatly appreciate it.
Thanks!
So as the title indicates, I don't know how to do this. I know how to make hyperlinks with VBA, but not on all visible pages.
Additionally, I was hoping to make every hyperlink retain whatever text is already in cell A2.
Here's why I'm doing it: I want to have people be able to navigate from my TOC's hyperlinks (which I've already created) to each worksheet, but also navigate back to the TOC via hyperlink. The reason why I want to keep the cell text is because I want to hide the link behind the title for the page (cell A2), as I don't want to rely on my team remembering to hide the link when it's time to put our client presentation into PDF.
If anyone can help me, I would greatly appreciate it.
Thanks!