How can I change the below code to only remove the pictures from worksheet "Imports" instead of all worksheets. Thankyou in advance!
VBA Code:
Sub BaDeletePictures()
' This macro removes all the pictures and objects that come over from the spreadsheet
Dim oPic As Shape
Dim wb As Workbook
Dim ws As Worksheet
'Loop through all worksheets
For Each ws In ActiveWorkbook.Worksheets
'Loop through all objects in the selected worksheet
For Each oPic In ws.Shapes
'Delete object
oPic.Delete
Next oPic
Next ws
End Sub