I currently have the following code which selects the worksheets and prints them. I want to have a menu page where the user can say yes or no to the title of the worksheet they want and press a button to run a macro which will then select the worksheets which the user has said Y too and then print them to PDF as one single PDF and not loads of individual PDFs. I have an excel workbook in excel 2007 which has approx 110 separate worksheets.
