PDF named worksheet and defined print area

[shayej]

Hi,

this is almost like an addition to another post i have seen. where someone did provide very useful code to pdf the named worksheets.

i wanted to know if it is possible to expand the code to include customised print area for each worksheet and it should be scaled to fit all column in one page.

here is a sample spreadsheet. List1 worksheet has the list of worksheet which needs to be included when it is pdf and also has print areas for each page.

Smple list.xlsx

i would really appreciate if you can share a full code for include print area for selected worksheets. Thank you in advance.

the code for just pdf named worksheet is:

Please Login or Register  to view this content.

[davesexcel]

First set your print areas manually for each sheet, when you PDF the sheets, they will PDF according to each sheet print settings.

You can pdf just the selected sheets, you don't need to create a new workbook.

Please Login or Register  to view this content.