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 FCCA
www.BygSoftware.com
Home of "Byg Tools for VBA" and "The Excel Auditor"
"A0" <oth...@main.aquanet.co.il> wrote in message
news:OD4$vPeRCHA.1676@tkmsftngp12...
http://www.j-walk.com/ss/excel/eee/eee002.txt
--
David Hager
Excel MVP
Baton Rouge, La.
A0 wrote in message ...
Other references to this Macro included a leading "#RANGE!"
I don't know what this is referencing. Do you?
"Range" is not a specific Module, or anything else I can figure out.
Do you know HTML to know what this is trying to do.
Perhaps this is referring to the button, or cell, to which this Hyperlink is
assigned???
Here is a copy of the code...
href="#RANGE!Recorded_Macro"><area shape=Rect...etc
Also, I have never been able to figure out how to include a specific module.
Do you know how?
Just a side question. Didn't earlier versions require 3 backslashes? One
of Microsoft's Hyperlink examples used something like "C:\\\..." and pointed
to the workbook, module, and program name. But, I don't remember anymore.
Thanks for any information.
--
Dana DeLouis
Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"Andy Wiggins" <ngr...@bygsoftware.com> wrote in message
news:kXr79.2593$KQ6.1...@newsfep1-win.server.ntli.net...
If I create the hyperlink with #Delete_XYZ then the
link works fine even though if you Edit hyperlinks nothing shows.
You can delete the *unseen* hyperlink with the button and
the link will be removed.
My interest was providing a hyperlink to subroutine or to a
function in my [personal.xls]
but it appears that this involves a named range so can only
apply to the current workbook. **any comments**
Incidentally have been using GOTOSUB subroutine
which probably serves the same purpose and allows me
to enter personal.xls!macroname into a cell and
use the GoToSub (coding can be seen in:...)
http://www.mvps.org/dmcritchie/excel/code/buildtoc.txt
macro to goto the subroutine entered in a cell
Application.Goto Reference:=Trim(ActiveCell.Value)
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> "Andy Wiggins" <ngr...@bygsoftware.com> wrote in message
> [...creating a HYPERLINK to a VBA module ....]
If the answer is obvious -- no conflicting answers an email would
be an alternative way to provide a Thank You. If you are tempted
to ask an additional question with the Thank You, stick to the
thread (same subject) or post a new question so others also benefit..
Thank you for asking the question, we're continuing the discussion
in your original thread.
http://google.com/groups?as_umsgid=OD4%24vPeRCHA.1676@tkmsftngp12
Since you are using Outlook Express, it might be useful to create
rule and a view to spot your own postings, select your post, then switch
from "Hide Read Messages" to "Show All Messages" to help
see the entire thread. More information on OE5 and OE6
http://www.mvps.org/dmcritchie/excel/OE5.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"A0" <oth...@main.aquanet.co.il> wrote in message news:OVOMxJfRCHA.1784@tkmsftngp12...
For Office XP, it is at:
"...Microsoft Office\Office10\Samples"
Same for earlier versions. :>)
--
Dana DeLouis
Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"David McRitchie" <dmcri...@msn.com> wrote in message
news:#7sB#PhRCHA.1496@tkmsftngp11...
I wonder why MS would add the capability to hyperlink to a VBA procedure,
but not to a Chart sheet?
John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss
"Andy Wiggins" <ngr...@bygsoftware.com> wrote in message
news:kXr79.2593$KQ6.1...@newsfep1-win.server.ntli.net...
As well as Chart sheets, I don't think it's possible to link to anything in
a class modules, user forms or sheet modules. But even in its limited form I
have found it very useful especially whilst working on client projects and
also in some of the demonstration workbooks I provide.
On client projects I create an "index" sheet containing links to the main
procedures. For example, I will try and include as least one procedure from
each module. When you have several workbooks open this is a quick way to get
to either the right place, or very near to it! It's also a useful way of
creating some basic (ho ho) documentation.
Sorry Dana, I'm as lost with Microsoft's HTML description of workbooks as
you appear to be :-)
Regards
Andy Wiggins FCCA
www.BygSoftware.com
Home of "Byg Tools for VBA" and "The Excel Auditor"
"John Walkenbach" <jo...@j-walk.com> wrote in message
news:eQlHPgiRCHA.1648@tkmsftngp08...
At least that's my opinion until someone can point to where
it's usage is actually documented. Remember it works but
does not show up in Edit Hyperlinks, and noone has shown
that it works to for the other open workbooks as well.
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Dana DeLouis" <ng_...@hotmail.com> wrote in message news:eyrFqciRCHA.2548@tkmsftngp12...
John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss
"David McRitchie" <dmcri...@msn.com> wrote in message
news:O$pt03lRCHA.4088@tkmsftngp09...