I use some code to just search all cells within the workbook for something I
know is going to be present in a pathname used in such a link. E.g. G:\ or
something similar. Problem with doing any formatting to a cell is
restoration of the previous format. How and where do you preserve it? If
you know in advance all cells have a white backgorund or whatever that's
fine.
I've used cell comments for this kind of thing in the past. This way you
get a nice unobtrusive indicator which you can then hover your mouse over to
get a detailed description. Again it falls victim to the preservation
issue.
The link finder I wrote just lists the entries to a listbox on a form.
Patching the change event of the listbox with something which selects the
cell will give you a nice way to jump through the entries.
Anyway hope it gives you some ideas.
--
Regards,
Bill Lunney
www.billlunney.com
"Phil Hageman" wrote in message
...
This is an ongoing thread that I have updated (changed my
idea...).
Want to put code in my "Personal Macro Workbook", attach
it to a menu button: when user clicks the button, all
cells in the active worksheet having links to other cells
(wherever located) are highlighted. An alternative could
be to make a list. If the cell already has a background
color, could the background color be restored upon
clicking the same button, or a second button. If not, can
exit without a save.
The objective is to know where all links are at a single
glance - with the click of a menu button.
Any suggestions to do this more effectively is appreciated.
Thanks, Phil