hi
have a question
i have 2 userforms and a couple of excel sheets
if i add a hyperlink to a sheet and tranfer it to userform mfr, it appears there but i have to then transfer to userform 3 before i can print the associated link which works but seems long winded,is there another way to print it off first screen formmfr ,the code and module was taken from the web not sure if it was this site or not
but as i said works perfectly, any ideas please
enter 2234 in ainscough box click search double click on first entry in list box ,pdf needs to be on desktop ,click print contract userform 3 appears click print and it shows pdf if your link is good from sheet mfr
cheers colin
Bookmarks