Hyperlink to sheet saved as pdf at time of saving

[nighttrainrex]

Hi all

here goes I have a "Active X' button that I use to save a sheet to a folder in PDF format and add the sheet information to an index sheet.

What I would like is to be able to add a hyperlink to the saved PDF and the details on the index sheet,

this is what I have so far

Thanks for looking Rex.

[nighttrainrex]

Hi all,

Managed to work my way through this one & got it to work so I thought I should post the solution may be of use to some one

cheers rex.