Dynamic Hyperlinks to Excel Tabs

By chefjohncourtade ·
I have an Excel workbook that is used to document Test Cases when we do manual testing. The new boss wanted more functionality by having a build in test matrix. I adding all of his requested features except for the hyperlinks to the tabs. I have a button that grabs certain information from each test case and populates it into the matrix, but I have been unable to figure out hoe to turn one piece of that data into a hyperlink. The Matrix is populated dynamically each time the button is pressed, so I can not hard code the tab names explicitly in to the VB editor.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Create Index Page For Workbooks

by cpfara In reply to Dynamic Hyperlinks to Exc ...

Maybe this can be util for you, in this site are a lot of this..

Create Index Page For Workbooks - Excel Help & Excel Macro HelpI have many workbooks with a lot of worksheets in each of them, how can I quickly add an index page, with links to each of the worksheets in the workbook, ...

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums