Button to PDF certain pages

[mjwillyone]

Friends,

I am wanting to create a button in an Excel 2007 spreadsheet that will print-to-PDF three pages of a multi-page workbook.

The pages are named: income, expense, and profit.

Can this be done?

Thank you!
Mike

[Justair07]

I'm not sure why you need to convert to pdf first if your just printing them. Here is a solution to simply print the three sheets you mentioned.

Please Login or Register  to view this content.

Another way is to create an array an do a loop, but since you only have 3 sheets this is just as easy.

[mjwillyone]

Thank you!

The reason it will be put in PDF format is that those pages will be sent to someone by email. I do not wish them to have the spreadsheet but want them to see those particular pages.

Mike

[Justair07]

If your looking to automate emailing worksheets as PDF's you can take a look here: http://www.rondebruin.nl/win/s5/pdf.htm

hope this helps,