Advertisement
Advertisement
| 01.26.2008 at 12:57PM PST, ID: 23113752 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: |
Sub RemoveAllShapes()
Dim shObj As Object 'Worksheets and Chart sheets
Dim s As Shape
Dim i As Long, ttl As Long
For Each shObj In ActiveWorkbook.Sheets
ttl = shObj.Shapes.Count
For i = ttl To 1 Step -1
shObj.Shapes(i).Delete
Next
Next
End Sub
|