Page headers in grouped sheets

[HoThereSmallFry]

Hello

I have a work book with lots of sheets in it. One of the tabs (which prints on several pages) has a header set up using the 'Different header on first page option'. This works fine when I just print this one sheet.

However, when I group sheets together and export them into a pdf, excel drops the different first header form this sheet (persumably because, as they are grouped, it no longer see it as a first page). Is there anyway around this?

Thanks
Adam

[Dimitrov]

HoThereSmallFry,

Sometimes when you cannot climb over a mountain, you go around it to get to the other side. As such, this will help you get around your question (and should get you the same result). Paste the code below into an empty module (of your spreadsheet) in your Visual Basic Editor, and run it. It will ask you to select a directory (i.e., folder) into which you want to save your PDF files. Once you select the directory, it automatically prints each tab into its own PDF file (no manual intervention required!). Each PDF file is named according to the tab (so you may wish to name each of your tabs in your workbook something different for the purpose of using this VBA procedure). Once you have your individual PDF files (which will avoid the header problem you described), you can use Adobe's Combine Files into a Single PDF feature to build one PDF from all the individual PDF files (if such assemblage is what you are looking for) and have the PDF files appear in the order that you want. In fact, with a judicious naming of the tabs in your spreadsheet (e.g., Sheet001, Sheet 002, Sheet003, etc.), the PDF files will line up right in this order.

Please Login or Register  to view this content.

Hoe this helps.
______________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].