I have a workbook with several worksheets of data and one worksheet of forumulas which does a lot of calculations. In one column on this calculation worksheet there are hyperlinks derived from URL's found on the preceding data worksheets.

This last calculations worksheet is delivered to clients. The other data pages are not and they need to remain confidential. So, to break the links with the other worksheets I copy paste the values of the last worksheet to a new workbook and send it to the client.

Unfortunately, the hyperlinks are lost in this process as they can no longer find the URL's.

Is there a way to copy/paste hyperlinks from my last worksheet to another workbook and have the hyperlink retain the URL?

Thanks for any assistance that's offered.

LongFisher