Automated Hyperlinking

M

mitch

I've written a macro that will duplicate a template worksheet and rename it
based on what is written in the userform's textbox. I've made the macro add
the value in the textbox to a list. I am now trying to add a hyperlink from
the cell in the list to the duplicated worksheet. Here is my code:

Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveCell.Value = Textbox1.Text
Sheets("Template").Select
Sheets("Template").Copy after:=Sheets("Ingredient Template")
Sheets("Template (2)").Name = Textbox1.Text
Range("A1").Select.Value = Textbox1.Text
Sheets("Overview").Select
Range("A65536").End(xlUp).Select

Any ideas on hyperlinking the newly populated cell to the newly duplicated
worksheet?
 

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

Similar Threads

VBA for Dependents shortcut menu 0
Macro not working correctly 3
Getting Radio Buttons to work, that are inserted via AutoText 0
Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet 1
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
Excel 2007: Creating a macro that will run Solver. 0
Code to format cells on several worksheets 2

Top