Excel Macro to hyperlink an archived worksheet to an index page


Joined
Feb 10, 2017
Messages
1
Reaction score
0
Hello,
I need a macro to assign to a control button that will create a hyperlink of the worksheet name to a Main page. In addition, it will need to fall within a range down a column, and find the empty cell two rows down from the last entry. For example, the first hyperlink will create on Cell G7, the next hyperlink will create on Cell G9 and so forth.

Thanks to all in advance!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top