Automated Hyperlinking

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automated Hyperlinking	mitch	Microsoft Excel Misc	0	16th Feb 2009 08:22 PM
Automated signature updates w/o using Windows Automated Updates	=?Utf-8?B?Q3VydEI=?=	Security Signatures	3	15th May 2006 01:31 AM
Automated Hyperlinking	=?Utf-8?B?QnJvb2tzIFcu?=	Microsoft Excel Worksheet Functions	0	21st Apr 2005 03:50 PM
Automated filter? Automated replace?	=?Utf-8?B?Y3Jja3JqY2s=?=	Microsoft Excel Crashes	2	12th Jan 2005 11:09 PM
Hyperlinking	=?Utf-8?B?R0I=?=	Microsoft Frontpage	4	14th Dec 2004 01:36 AM