éåæææ§ä»¶ï¼é个å é¤å°±å¯ä»¥äºã
举ä¾è¯´æï¼
ä¾å¦æè¡¨æ ¼å¦å¾ï¼
第ä¸æ¥ï¼æå ¥æ¨¡åï¼ç¼å代ç å¦ä¸ï¼
Sub test()
Sheets("sheet1").Activate
For Each myc In ActiveSheet.Shapes
myc.Delete
Next myc
End Sub
第äºæ¥ï¼è¿è¡å®testãå¦å¾ï¼
ç»æå¦å¾ï¼
Sub 删除插件()
For Each ws In Worksheets
On Error Resume Next
ws.Activate
For Each i In ws.Shapes
i.Delete
Next i
Next ws
msgbox"操作完毕"
End Sub