VBA Macro for “selecting all shapes” in excel sheet

Use below VBA macro to “select all shapes” within a current excel sheet.

1. Sub selectAllShapesInExcel()
2. ActiveSheet.Shapes.SelectAll
3. End Sub

Advantages

1. Saves your time of selecting the shapes manually