Hyperlinks to code

Q: I saw a worksheet with hyperlink to VBA module. When you click on the hyperlink the VBE opens in a specific procedure. How can I do this?

A: Depends on which version of Excel you are using.

In Excel 97:
Insert > Hyperlink:
In "Named location in file (optional):" put the name of the procedure.
So if the procedure name is MyProc, you would enter "MyProc".

In Excel 2000:
Insert > Hyperlink:
Click on "Existing File or Web Page".
Then in "Type the file or Web-page name" put the name of a procedure preceeded by a hash (#).
So if the procedure name is MyProc, you would enter "#MyProc".

In Excel 2002 (XP) and Excel 2003:
Insert > Hyperlink:
Click on "Existing File or Web Page".
Then in "Address" put the name of a procedure preceeded by a hash (#).
So if the procedure name is MyProc, you would enter "#MyProc".
 

Published: 02-Feb-2004
Last edited: 01-Apr-2007 19:11