DisplayDrawingObjects Property

Microsoft Excel Visual Basic

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