DisplayDrawingObjects Property

Applies To

Workbook object.

Description

Returns or sets how shapes are displayed. Read/write Long.

Can be one of the following XlDisplayShapes constants.

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