Thread: Macro that makes a hyperlink

Hi All,
I'm trying to make a macro that can make a hyperlink from a cell to a worksheet.
Does anyone know how to do it?
Thanks in advance.

G'day,

Something like this?

http://www.excelforum.com/excel-new-...ink-macro.html

Thanks Arvin,
However, this macro copies from a constant worksheet to another constant worksheet.
What I am looking for is a macro that will make a hyperlink from the sell that I stand on to a different worksheet, named as the cell I am standing on.

Yes, to go to a different worksheet, doesn't matter to what cell in the sheet I move to