Workbook.DisplayDrawingObjects Property

Excel Developer Reference

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.

Visual Basic for Applications
  ActiveWorkbook.DisplayDrawingObjects = xlHide

See Also