Delete Boxes in cell?

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,626
Office Version
365
Platform
Windows
Depends on what they are.
1) try right clicking to select it.
2) On the developer tab, click "Design Mode" then click the object.
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,337
Office Version
2019, 2016, 2013
Platform
Windows
Maybe
VBA Code:
Sub clean()
    Dim Ws As Worksheet
    For Each Ws In Worksheets
        Ws.DrawingObjects.Delete
    Next Ws
End Sub
try it on a copy first
 

Watch MrExcel Video

Forum statistics

Threads
1,099,022
Messages
5,466,093
Members
406,464
Latest member
buks1232000

This Week's Hot Topics

Top