Removing all screen shots from a excel sheet

Learning Hub Academy Feedback
1

Hi All,

Can some one tell me how to remove existing screen shots from excel sheet

Thanks !!

2

Can you clarify your query with screenshots please

3

Can you send a sample excel file?? @Hitesh1

4

Example - in a excel sheet already some screenshots will be there

Or we can say some one has pasted screenshots in excel sheet that i want to remove

Please let me know if you need any other clarification

5

The Excel contains only screenshots? or along with other content you have screenshots?

6

I have content as well…Test.xlsx (120.9 KB)

Please find the attached sheet for reference.

Thanks for the response.

7

with VBA:

Sub RemoveScreenshots()
Dim Img As Object
For Each Img In ActiveSheet.Pictures
Img.Delete
Next Img
End Sub
1 Like
8

Here is a solution with excel.Interop.

9

Thanks Peter , i will try this

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.