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