Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

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?

Re: portrait vs. landscape

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'.

HTH

Mark

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.