Creating a PDF of two Sheets from a workbook

Hello All,

I have created a Quoting Spreadsheet and have one last thing I must create. Right now I have a macro that will eliminate all rows with a "0" quantity and hide the Unit Pricing column. Only sectional pricing is shown. I also have several sheets for informational purpose when creating the quote.

After the quote has completed and the rows have been eliminated and the column hidding, I would like a macro that would create a PDF of the first two sheets of the workbook. I would like a pop-up to enter in the file name prior to creating the PDF. Once the PDF is created, I would like it to open up so that the account manager could take a look at it before either printing or emailing to the customer.

Any ideas are greatly appreciated.

Thank you,
Rick

Hi Group,

Lots have looked but no replies?