Print multiple selected worksheets to separate PDF's

Hi,

I have the following code which I am using to print to PDF

Please Login or Register  to view this content.

It's working for what I need but it could be just a little bit better. Currently I have to use the macro to print each worksheet separately to get a separate PDF document. Is it possible to adapt this slightly? Basically it would be great if the macro would print each worksheet in the workbook containing text "Invoice" in the worksheet name to a separate PDF, the filename and path to remain as is in the code above. I also like the 2 second delay.

Workbook is called Header & Footer (if this is required).

Many thanks for any assistance which can be provided.

Hi,

Thanks for your reply. I couldn't get the code to work. I have adapted the code slightly (below) and it's now working but only for the first worksheet containing "Invoice". When it comes to the second tab it's getting stuck at Save As dialog box. Looks like can't follow macro code to create file name required. Does this make sense?

Further help would be greatly appreciated. Thanks.

Please Login or Register  to view this content.

Getting this macro to work is the final step in a series of macro I've not got to really improve a process, would appreciate any assistance anyone can provide. Thanks.