Workbook.DisplayDrawingObjects (Excel)

Returns or sets how shapes are displayed. Possible return values are xlDisplayShapes - Show all shapes, xlHide - Hide all shapes, xlPlaceholders - Show only placeholders.

Can be one of the following XlDisplayDrawingObjects constants: xlDisplayShapes, xlPlaceholders, or xlHide.

ActiveWorkbook.DisplayDrawingObjects = xlDisplayShapes