Mark Tangard wrote:
If you leave the hyperlink base blank, then all hyperlinks will be
relative to the workbook that contains them - with a few exceptions.

Gawd. Didn't realize it'd be *that* simple. Thanks so much for
recognizing my blind spot. But, what are the exceptions?

The ones I mentioned: Unsaved workbook results in absolute links until you
save it; and links on a different drive or path. There may be more
exceptions, but those are the two I know.


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com