Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



can't delete image in excel sheet

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-06-2009
Member
 
Join Date: Mar 2009
Posts: 37
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.....!

Reply With Quote
  #2  
Old 08-06-2009
Member
 
Join Date: Apr 2008
Posts: 4,642
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.
Reply With Quote
  #3  
Old 08-06-2009
Member
 
Join Date: May 2008
Posts: 3,314
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
Reply With Quote
  #4  
Old 08-06-2009
Member
 
Join Date: Apr 2008
Posts: 4,097
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
Reply With Quote
  #5  
Old 13-10-2010
Member
 
Join Date: Oct 2010
Posts: 1
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.
Reply With Quote
  #6  
Old 03-11-2010
Member
 
Join Date: Nov 2010
Location: Texas
Posts: 1
smile 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.
Reply With Quote
  #7  
Old 30-01-2012
Member
 
Join Date: Jan 2012
Posts: 1
Re: can't delete image in excel sheet

Quote:
Originally Posted by Majuba View Post
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!!
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "can't delete image in excel sheet"
Thread Thread Starter Forum Replies Last Post
How to use Mail Merge from one Excel Sheet to another Excel Sheet Abélard MS Office Support 2 23-02-2012 01:59 PM
What is the use of time sheet in excel Chini mao MS Office Support 1 08-01-2012 03:35 PM
Script to change excel sheet Miles Runner Windows Software 5 21-01-2010 12:54 PM
Does Excel sheet has Line Limitation Aanand Software Development 2 19-06-2009 11:17 AM
Fax an Excel sheet From a Computer Addis Tips & Tweaks 1 24-10-2008 01:03 PM


All times are GMT +5.5. The time now is 07:03 PM.