View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg[_27_] Greg[_27_] is offline
external usenet poster
 
Posts: 50
Default Hyperlink question

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