正在加载中...

信息详页

返回
批量删除工作薄中各工作表中的图片


来源:转载 浏览量:165 次 发布日期:2021-02-26

Sub Clear_pics()
Dim jpg As Shape
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
For Each jpg In ws.Shapes
jpg.Delete
Next jpg
Next ws

End Sub


Sub aa()

For Each sht In ThisWorkbook.Sheets
sht.DrawingObjects.Delete
Next
End Sub