excel批量删除多个表格的照片宏
Sub DeletePictures() Dim sh As Worksheet Dim pic As Picture
For Each sh In ActiveWorkbook.Worksheets For Each pic In sh.Pictures pic.Delete Next pic Next sh
End Sub
原文地址: http://www.cveoy.top/t/topic/Lgd 著作权归作者所有。请勿转载和采集!
安全问答是一个知识全球问答,包含丰富的问答知识
Sub DeletePictures() Dim sh As Worksheet Dim pic As Picture
For Each sh In ActiveWorkbook.Worksheets For Each pic In sh.Pictures pic.Delete Next pic Next sh
End Sub
原文地址: http://www.cveoy.top/t/topic/Lgd 著作权归作者所有。请勿转载和采集!