엑셀
엑셀 vba 사진삭제
아스C#
2018. 11. 28. 00:00
반응형
Sub 사진삭제()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Dim s As Shape
For Each s In ActiveSheet.Shapes
If s.Type = 13 Then
s.Delete
End If
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
.
반응형