Delete all shapes from active worksheet.
Author: michael@excelexperts.co.uk
Sub DeleteShapes() Dim Shp As Shape Call TurnOff For Each Shp In ActiveSheet.Shapes Shp.Delete Next Shp Call TurnOn End Sub
Delete all shapes from active worksheet.
Author: michael@excelexperts.co.uk
Sub DeleteShapes() Dim Shp As Shape Call TurnOff For Each Shp In ActiveSheet.Shapes Shp.Delete Next Shp Call TurnOn End Sub