XL97: Cannot Use xlDisplayShapes with DisplayDrawingObjects (163741)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q163741 SYMPTOMS
When you run a Visual Basic for Applications macro that refers to the
DisplayDrawingObjects property of Microsoft Excel 97, you may receive the
following error message:
Compile error:
Type mismatch
CAUSE
This problem occurs when your macro contains a line of code that is similar
to the following:
ActiveWorkbook.DisplayDrawingObjects = xlDisplayShapes
WORKAROUND
To prevent this problem from occurring, use the constant xlAll instead of
the constant xlDisplayShapes. For example, change the sample line of code
to the following:
ActiveWorkbook.DisplayDrawingObjects = xlAll
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem no longer occurs in
Microsoft Excel 2000.
NOTE: The information that is in the Help topic for the
DisplayDrawingObjects property is incorrect.
Modification Type: | Major | Last Reviewed: | 10/21/2000 |
---|
Keywords: | kbdocerr kberrmsg kbProgramming KB163741 |
---|
|