• Delete all Shapes in Excel Workbook

    In Excel a shape object can be:

    A square box, round, call outs, star, arrow, line etc.,

    Do you want to clear all these shapes from all worksheets? Then use this code.

    Note: But just remember: Once the object is deleted & workbook is saved, the same shape cannot be recovered.

    You only have to recreate these shapes dynamically again.

    This code loops through each shape in the sheet & delete shapes, all of it, one by one, from the all worksheets.

    If you have accidentally deleted any shape from the spreadsheet, then you will not be able to recover it again. You can only create a new one from Menu -> Insert -> Shapes or through dynamic shape creation.

    What if we need to create only specific shape and not all?

    Also Read: Check If Outlook is Running - then Launch Outlook app - vba code

    Delete Shapes with Name

    One idea to delete specific Shape is to use its name.

    If not that, You can also choose other property of a shape like Title, Top, Width, height etc.,

    Inside code, check whether the property of any the shape matches with the value. If it matches then use .Delete on it.

    Previous Post:
    Next Post: