How to avoid volatile hyperlinks?
 

Hi,
A worksheet has column of hyperlinks pointing to files in /Invoices folder -
VBA code placed them there.
After copying the workbook to a different location, hyperlinks fail and
baloon tip shows completely different folder it wants to see the file in.
What gives?
How to have hyperlinks constant?
TIA
Paul

How to avoid volatile hyperlinks?
 

Give Excel a break! If you change the folder of a linked file, it's u
to you to remedy the problem

--
raypayett

-----------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...fo&userid=2956
View this thread: http://www.excelforum.com/showthread.php?threadid=57330