excel如何使用vba删除所有对象

2024-11-26 09:46:01
推荐回答(1个)
回答1:

Sub deleteob()
For i = 1 To ActiveWorkbook.Worksheets.Count
Dim o As Object
For Each o In Sheets(1).Shapes
o.Delete
Next o
Next i
End Sub