以下是 VBA 代码,可用于删除 Excel 中所有工作簿中的图片:
Sub DeleteAllImages()Dim ws As WorksheetDim shp As ShapeFor Each ws In ThisWorkbook.WorksheetsFor Each shp In ws.ShapesIf shp.Type = msoPicture Thenshp.DeleteEnd IfNext shpNext ws
时间:2023-04-07 14:27:47
以下是 VBA 代码,可用于删除 Excel 中所有工作簿中的图片:
Sub DeleteAllImages()Dim ws As WorksheetDim shp As ShapeFor Each ws In ThisWorkbook.WorksheetsFor Each shp In ws.ShapesIf shp.Type = msoPicture Thenshp.DeleteEnd IfNext shpNext ws
[No0000C1]Excel 删除空白行和空白列VBA代码
2020-02-20
Excel单元格插入图片并实现单击放大或缩小功能(含VBA代码)
2021-03-11