Results 1 to 7 of 7

Thread: can't delete image in excel sheet

  1. #1
    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.....!

  2. #2
    Join Date
    Apr 2008
    Posts
    4,644

    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.

  3. #3
    Join Date
    May 2008
    Posts
    3,319

    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

  4. #4
    Join Date
    Apr 2008
    Posts
    4,089

    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

  5. #5
    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.

  6. #6
    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.

  7. #7
    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!!

Similar Threads

  1. Replies: 2
    Last Post: 23-02-2012, 01:59 PM
  2. What is the use of time sheet in excel
    By Chini mao in forum MS Office Support
    Replies: 1
    Last Post: 08-01-2012, 03:35 PM
  3. Script to change excel sheet
    By Miles Runner in forum Windows Software
    Replies: 5
    Last Post: 21-01-2010, 12:54 PM
  4. Does Excel sheet has Line Limitation
    By Aanand in forum Software Development
    Replies: 2
    Last Post: 19-06-2009, 11:17 AM
  5. Fax an Excel sheet From a Computer
    By Addis in forum Tips & Tweaks
    Replies: 1
    Last Post: 24-10-2008, 01:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •