Hi

I have a document that uses hyperlinks. At the moment, I am inserting
indivual hyperlinks which inserts the file location for each sheet and the
display text. This file is over 200 pages and I need to learn of an easy way
to edit each hyperlink easily.

Is this possible?

Thanks

Let's say you are creating the hyperlinks using:

Insert Hyperlink

and editting them the same way.

Instead, put the address in column A and the text in column B, then in C1
enter:

=HYPERLINK(A1,B1) and copy down. This will produce a nice "click-able"
table of hyperlinks. You can change the links anytime without having to use
the DialogBox.
--
Gary''s Student - gsnu200786


"forest8" wrote:

Hi

I have a document that uses hyperlinks. At the moment, I am inserting
indivual hyperlinks which inserts the file location for each sheet and the
display text. This file is over 200 pages and I need to learn of an easy way
to edit each hyperlink easily.

Is this possible?

Thanks