Excel 2010 - Sheet with Macros and VB Script having issues after upgrading from Excel 2003
Posted on 2012-09-12
We have upgraded from Excel 2003 to Excel 2010. There is a very complicated sheet that has a lot of macros with VBScript attached to it that worked fine in 2003, but now in 2010 Excel we have issues that we cannot get to the source of.
The biggest issue now is, during a print preview, if we do a shrink to fit, when we come back to the page to print it, the sheet has every page set as a page break. (This is with a network print queue selected). If we do the same thing with Adobe PDF Creator set as the printer, we can shrink the sheet to print on 1 single page without issue, and when we get back to the sheet to print, we do NOT get the page break issue. Currently, this is our workaround, printing to PDF, then opening the PDF and printing the PDF from within Adobe reader.