If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hyperlinks to Code
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 |
Thread Tools | |
Display Modes | |
|
|