Microsoft Excel Hangs If Macro Contains PageBreak Property
Article ID: 134409
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q134409
SYMPTOMS
In Microsoft Excel, when you run a macro that contains the PageBreak
property, you may receive a general protection (GP) fault or an application
error.
CAUSE
This problem occurs if you run a macro that contains the PageBreak property
if you do not have a printer installed on your computer. The PageBreak
property returns or sets the location of a page break on your worksheet.
However, if you use the PageBreak property in a macro when you do not have
a printer installed, you receive a GP fault.
Note that Microsoft Excel uses the installed printer to determine where a
page break is located or needs to be inserted on a worksheet.
RESOLUTION
To avoid this problem, install a printer on your computer. For more
information about installing a printer under Windows or Windows NT, see
your printed documentation or online Help.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
REFERENCES
For more information about "PageBreak Property," choose the Search button
in Visual Basic Reference Help, and type:
Additional query words: gpf crash print hang XL
Keywords: kbprogramming KB134409