Hi all,

I am wondering how I can have a hyperlink added to a worksheet
automatically.

I have my project so the user can input the information the program asks
for, then it names the page based on the cell reference. What I need is a
macro to take the name of the worksheet and have the hyperlink appear in
range a1 on a worksheet called "links".

I have tried to use the recorder but it only reads from the sheet I am
currently testing. Any ideas would be great
I would post the code I have but it is very long.

Thanks
Greg

I am not too sure of what you are asking for but .....

the formula for hyperlink is something like "=hyperlink(link to
resource,display text)"

so if you have a variable that gets the user input, then you can write a
simple code like worksheets("name_of_sheet").range("A1").value =
"hyperlink(user_input,links)".

explain a bit further if this is not what you are asking.

"Greg" wrote:

Hi all,

I am wondering how I can have a hyperlink added to a worksheet
automatically.

I have my project so the user can input the information the program asks
for, then it names the page based on the cell reference. What I need is a
macro to take the name of the worksheet and have the hyperlink appear in
range a1 on a worksheet called "links".

I have tried to use the recorder but it only reads from the sheet I am
currently testing. Any ideas would be great
I would post the code I have but it is very long.

Thanks
Greg