Scroll down until you find Print Preview. Choose All Commands from the left dropdown. This seems to me just wrong - if you write in code 'windows('whatever'). Strategy: Customize the Quick Access Toolbar as shown back near Fig 42. Window, click on the window zooms it) but that is not enough.Īs far as I can see this problem exists in Excel 2013, but not in Excel 2010.Ĭan someone tell me what I am doing wrong? Or how to work around this?Īt this opportunity I also ask: according to the excel vba documentation, PrintPreview is also a method of the window object. There are some substitutes (escape lets you close the print preview The print preview appears, but the icons above it (print, setup, zoom, close) are inactive. In Excel 2013, you may have rows or columns on the spreadsheet that you do not want to print when printing the spreadsheet. If the open window is Report1.xls and one calls this routine, everything works fine.īut if the open window is Program1.xls and one calls this routine, there are problems. That is enough code to illustrate the problem (and probably some of that superfluous). In a module in workbook 'Program1.xls' there is simple code: We were wondering why the preview didn't already come up, especially since the other. Clicking on the button brings up the print preview, which isn't all that difficult. Two or more workbooks are open - say Report1.xls and Program1.xls (yes, 2003 workbooks but I do not think this is the problem). On only one worksheet when we click on File and Print, instead of seeing the print preview on the right side of the screen, there's a button that says 'Show Print Preview'.

Excel 2013 print preview