I've found a TON of great posts on here so I thought I'd see if anyone here can figure this one out...
I have a userform created that has a dropdown box. This is a list of products that are defined on sheet 1 as "SKU". Sheet 1's sku numbers are hyperlinks to an online PDF form. When the user clicks "Print" on the userform, I need it to find that specific sku and print the PDF that results from the hyperlink.
I would prefer that the user never sees the sheet, it only opens the userform. I would also prefer the user never actually see the PDF sheet, it simply prints to their default printer.
Am I chasing rainbows here? No one has found an answer for me as yet.
Would help to attach a sample sheet. The hyperlinks don't go to a PDF but same concept
https://www.dropbox.com/s/3sp4uupk7jsxjqx/test%20workbook.xlsm?dl=0
I have a userform created that has a dropdown box. This is a list of products that are defined on sheet 1 as "SKU". Sheet 1's sku numbers are hyperlinks to an online PDF form. When the user clicks "Print" on the userform, I need it to find that specific sku and print the PDF that results from the hyperlink.
I would prefer that the user never sees the sheet, it only opens the userform. I would also prefer the user never actually see the PDF sheet, it simply prints to their default printer.
Am I chasing rainbows here? No one has found an answer for me as yet.
Would help to attach a sample sheet. The hyperlinks don't go to a PDF but same concept
https://www.dropbox.com/s/3sp4uupk7jsxjqx/test%20workbook.xlsm?dl=0