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


  1. Saves your time of selecting the shapes manually

About the Author


A passionate blogger. Love to share solutions and best practices on wordpress hosting, issues and fixes, excel VBA macros and other apps

Leave a Reply

Your email address will not be published. Required fields are marked *