DisplayDrawingObjects Property

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

Can be one of the following XlDisplayDrawingObjects 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