can't delete image in excel sheet

I am working in a Call Center Back office & has a lot of data kept in it. But today when i opened the file i saw that someone has inserted image in it. I tried deleting/removing it but was not worthy as it cannot be deleted by the means of removing/deleting as the way i was knowing. Can someone help with this. Please Help.....!

Select the file or image & then delete it directly from there or you can go to Edit option & can cut it from there. Also you can remove it by moving that file to the different sheet but should be blank & then can delete that sheet directly.

The following code will solve your problem of deleting picture from excel :

Code:

---

Dim eqn, pic, graphics, sh, temp, shAddress, shCount, shName
Set graphics = Sheets("Graphics")
shCount = ActiveSheet.Shapes.Count
If shCount = 0 Then
Else
    For Each sh In ActiveSheet.Shapes  'Find and delete the existing equation box & schematic
        shCount = ActiveSheet.Shapes.Count
        shName = sh.Name
        Select Case Left(LCase(shName), 3)
        Case "pic", "eqn", "obj"
                sh.Delete              'Delete it
        Case Else  'Don't delete drop-down lists or other shape objects
        End Select
    Next sh
End If

---

Try this Macro on the Excel file after taking the backup of that file :

Code:

---

Sub Macro1()
Dim ShapeName As Shape

For Each ShapeName In ActiveSheet.Shapes
ActiveSheet.Shapes(ShapeName.Name).Delete
Next ShapeName
End Sub

---

The problem might be that the workbook is being Shared. Turn that off, and you might be able to select and remove the image.

Try resizing the image to zero by zero. That was the only way I could get rid of my company logo from the top of my spreadsheet.

Quote:

---

Originally Posted by Majuba

The problem might be that the workbook is being Shared. Turn that off, and you might be able to select and remove the image.

---

That worked for me!!