You cannot use page setup properties in Excel if no printers were installed

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q291298
For a Microsoft Excel 2000 version of this article, see 213516.
For a Microsoft Excel 98 version of this article, see 182243.
For a Microsoft Excel 97 and earlier versions of Excel version of this article, see 172320.
SYMPTOMS
When you run a Microsoft Visual Basic for Applications macro that attempts to set or get the page setup properties for any sheet in a workbook in Microsoft Excel, you may receive either of the following error messages:
Run-time error '1004': Unable to set the x property of the PageSetup class
Run-time error '1004': Unable to get the x property of the PageSetup class
Note In these messages, x is any of the following words:
   BlackAndWhite        Order   BottomMargin         Orientation   CenterFooter         PaperSize   CenterHeader         PrintArea   CenterHorizontally   PrintComments   CenterVertically     PrintGridlines   ChartSize            PrintHeadings   Draft                PrintNotes   FirstPageNumber      PrintQuality   FitToPagesTall       PrintTitleColumns   FitToPagesWide       PrintTitleRows   FooterMargin         RightFooter   HeaderMargin         RightHeader   LeftFooter           RightMargin   LeftHeader           TopMargin   LeftMargin           Zoom				
CAUSE
This problem occurs when there are no printer drivers installed on yourcomputer. Excel cannot set or get page setup properties if noprinter drivers are installed.
RESOLUTION
To prevent this problem from occurring, install a printer driver on yourcomputer. Use the Printers option in Control Panel to add and remove printer drivers.
MORE INFORMATION
In Excel, page setup properties are only available when you print or preview one or more sheets in a workbook. Because of this, you cannot change or return most page setup properties unless at least one printer driver is installed as the default printer.

If you click Page Setup on the File menu when no printer drivers are installed, you receive the following error message:
There are no printers installed. Use the Printers option in ControlPanel to install a printer.
Just as you cannot access the Page Setup dialog box in this case, you cannot access the properties in the dialog box programmatically.

Note To open the Page Setup dialog box in Microsoft Office Excel 2007, press CTRL+F2, and then click Page Setup in the Print group.
prb XL2002 XL2003 XL2007
Properties

Article ID: 291298 - Last Review: 01/02/2007 22:20:01 - Revision: 3.0

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition

  • kbexpertisebeginner kberrmsg kbprb kbprogramming KB291298
Feedback