ExcelBanter - Wonky printout when I print entire workbook

Hi guys,

So I'm having a strange printing problem in Excel 2007. You would think that printing the entire workbook would have the same result as printing each worksheet separately. But that does not seem to be the case here.

I have several sheets with charts and tables on them, and I'm trying to print a summary report of all the sheets.

I have print areas and settings set up, and also macros that set the footer on each page. (see below for details)

After running the macros, I try to print. In the print dialog, under "Print what" I choose "Entire workbook". The result is pages that look, for lack of a better word, wonky. The chart overlaps the text, the footer's not even there, it's a mess. It looks like this: http://excelbanter.com/attachment.ph...1&d=1343327582

Then, immediately after that, I print again, this time choosing "Active sheet(s)" under "Print what", so that it only prints one of the sheets. And the pages are totally fine! Here's the non-wonky version of the page: http://excelbanter.com/attachment.ph...1&d=1343327582

Do any of you know what I'm doing wrong? Does it have something to do with the macro?

The macro I'm using is just this line of code, to set the footer to the value of a cell on the sheet:

Code:

Worksheets("Success Rate").PageSetup.LeftFooter = Cells(1, 2).Value

(Cell(1,2), or B1, has the "1/2011 - 11/2012" in it.)

Also, please just ignore the fact that there's currently no data. It's linked to another file, and it works when that file is open.

Thanks!!

TL;DR Added a macro, now it prints funny when I print the entire workbook, even though printing each sheet separately works fine.