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.....!
Re: cant delete image in excel sheet
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.
Re: cant delete image in excel sheet
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
Re: cant delete image in excel sheet
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
Re: can't delete image in excel sheet
The problem might be that the workbook is being Shared. Turn that off, and you might be able to select and remove the image.
Re: can't delete image in excel sheet
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.
Re: can't delete image in excel sheet
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!!