I have a workbook (Workbook1) that contains a macro. When the macro is run it
creates a hyperlink on one of the worksheets to another workbook(workbook2).
The hyperlink works fine until I click the save button to save the workbook1.
It then changes the hyperlink path and it no longer links to workbook2. What
is really confusing is that this only happens on a certain computer. When
its tested on other computers on the network it works no problem and anybody
can link to Workbook2 from Workbook1 hyperlink except for hyperlinks created
by the one computer. Any idea what the issue is?