Excel functions and macros

J · Jun 2, 2004

How can I create a function or macro that will alow me to
click on a cell and have that cell take me to a worksheet
within the document?

Stephen Bye · Jun 2, 2004

You can do this with the HYPERLINK function, for example:
=HYPERLINK(Sheet2!B2,"click here")

J · Jun 2, 2004

Hi! I tried this and it is not working. It won't bring
me to the page but shows the link.

J · Jun 2, 2004

I figured it out! Thank you very much!

-----Original Message-----
You can do this with the HYPERLINK function, for example:
=HYPERLINK(Sheet2!B2,"click here")

.