MrExcel Publishing
Your One Stop for Excel Tips & Solutions

portrait vs. landscape

Posted by Sherry on March 21, 2001 1:28 PM

Twice now we have had problems in Excel 2000 with print preview/print. We've told the progrma to print in landscape yet when we actually print or click on print preview, we get portrait. BUT LANDSCAPE IS CHECKED...........tried clearing the print area and re-setting...tried setting to landscape from printer folder in controls/settings....
Any suggestions?

Posted by mseyf on March 21, 2001 1:34 PM

Are there any macros in this file? if so, go the the Visual Basic Editor and look in 'ThisWorkbook' and see if there is 'BeforePrint' macro setting the orientation to 'Landscape'.