Hi "hyperlink" <
[email protected]> ,
Source Code for Excel ?? whatever would you do with it?
You can write a macro to go through your worksheets examining
each hyperlink and changing them if you are consistent.
There are also HYPERLINK Worksheet Functions,
and there are files associated with your own toolbar buttons,
if you are changing the location of your personal.xls then
the location may change..
There is a excel.links newsgroup that Bill Manville has almost
to himself and that would probably be the best place to look
at and to ask such questions.
A posting by Bill Manville to fix hyperlinks (fixhyperlinks, change hyperlinks)
can be found in excel.links 2002-10-18
http://groups.google.com/[email protected]
You want to loop through the worksheets, and through the
hyperlink collections. You can put that example within
going through the worksheets collection.
Collections
http://www.mvps.org/dmcritchie/excel/collections.htm .
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Barhopper -- fixup for Restored Toolbars,
and -- Listing of Menu Items
http://www.mvps.org/dmcritchie/excel/barhopper.htm
We are a friendly bunch here, in the Excel newsgroups, and it's a lot more
friendly and professional to use your first and last name when posting, so
we know who we are talking to. If Microsoft Communities does not make that
easy then please include your first and last name in your signature line.
