XL2002: Cannot Use Page Setup Property If No Printers Installed (291298)
The information in this article applies to:
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 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 x property of the PageSetup class
Run-time error '1004':
Unable to get the x property of the PageSetup class
where 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 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.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kberrmsg kbprb kbProgramming KB291298 |
---|
|