DisplayDrawingObjects Property [Excel 2003 VBA Language Reference]

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

Applies to | Workbook Object