Copy Sheet to New Workbook with Hyperlink

[dar149]

I have several hyperlinks in a workbook. I want to copy the sheet containing the hyperlinks to a new workbook using code. When I record the macro, they hyperlinks work in the new workbook. When I run the macro, it shows up as a hyperlink, but the link is broken and it goes nowhere. I used the move/copy command to copy the entire sheet to a new workbook. I also tried selecting all and pasting into a new workbook.

Any ideas??

 

[dar149]

I found that if I save the workbook the hyperlink is reestablished. However, because this program will be run from a cd that is read only, I am unable to save it. Can you think of any other way to establish that link?

 

[dar149]

I did try saving the workbook to the hard drive of the pc I'm running from, but the links remain broken.