Posted to microsoft.public.excel.links
|
|
display links
Perfect!
Thank you!
.....Linda
"Bob Flanagan" wrote:
Linda, take a look at the Link Finder at
http://www.add-ins.com/linkfind.htm. It can create a list of links for you.
Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
"Linda@LLBean" wrote in message
...
I have a support/source worksheet that I would like to list what links are
used (and tell the user when to update/why the link is there). Most of my
link names include the date, so this is also an additional control for the
user.
The Edit/Link function only shows a partial name, not the full name (and
I'd
have to instruct the user on how to do this).
The Tools/Options displays all links (will scare the heck out of my user!)
and again will truncate with the column width.
I was hoping to somehow create a formula that would show the text for the
referenced cell (ex: cell A1 on source document would be written as =
'summary page'A1 and would display the text in summaryA1 as
"C:server\path\link file.xls"
Thank you!
....Linda
"Linda@LLBean" wrote:
I would like to know if it's possible to "show links" that are in an
existing
document. I want to show the user what links are embedded in the
document.
Thanks!
....Linda
|