PDF all worksheets and print

[specops]

Is there a way of having a button on the last worksheet in a workbook which when clicked will PDF and print all the worksheets in the workbook.

[mdmackillop]

Have a look here (http://www.excelguru.ca/node/21).