Workbook.DisplayDrawingObjects Property (Excel)
Returns or sets how shapes are displayed. Read/write Long.
Syntax
expression .DisplayDrawingObjects
expression A variable that represents a Workbook object.
Remarks
Constant |
Description |
|---|---|
xlDisplayShapes |
Show all shapes. |
xlPlaceholders |
Show only placeholders. |
xlHide |
Hide all shapes. |
Example
This example hides all the shapes in the active workbook.
ActiveWorkbook.DisplayDrawingObjects = xlHide