Hyperlinks to Code

Hi,

I have been browisng through the samples.xls files that
installs with Office XP and was wondering how they made
the hyperlinks to open the VBE and show the code for a
specific procedure. I have tried anything, but cannot
simulate this. Can anyone tell me how?

Many thanks and kind regards
Vyyk

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):
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".


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"Vyyk Drago" wrote in message
...
Hi,

I have been browisng through the samples.xls files that
installs with Office XP and was wondering how they made
the hyperlinks to open the VBE and show the code for a
specific procedure. I have tried anything, but cannot
simulate this. Can anyone tell me how?

Many thanks and kind regards
Vyyk