I have a userform that requests a part number entry. When the user clicks the command button "Print", it needs to search through column D for that part number. Once it finds it, it then goes across to column AJ where there is an internet hyperlink to a PDF document. I need it to automatically print that PDF document without the user seeing anything. Preferably, they wouldn't even see the spreadsheet, I'd like it to open only the userform when they double click on the file, and go back to a blank userform when the document prints.