Microsoft KB Archive/213516

= XL2000: Cannot Use Page Setup Property If No Printers Installed =

Article ID: 213516

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213516



For a Microsoft Excel 2002 version of this article, see 291298.

For a Microsoft Excel 98 version of this article, see 182243.

For a Microsoft Excel 97 and earlier version of this article, see 172320.



SYMPTOMS
If 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, you may receive either of the following error messages

Run-time error '1004': Unable to set the  property of the PageSetup class

-or-

Run-time error '1004': Unable to get the  property of the PageSetup class

where  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 your computer. Microsoft Excel cannot set or get page setup properties if no printer drivers are installed.



RESOLUTION
To prevent this problem from occurring, install a printer driver on your computer. Use the Printers option in Control Panel to add and remove printer drivers.



MORE INFORMATION
In Microsoft Excel, page setup properties are only available when you print or print 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 Control Panel 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.

Keywords: kberrmsg kbprb kbprogramming KB213516

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.