+ Reply to Thread
Results 1 to 3 of 3

How to delete pictures without deleting other objects?

  1. #1
    Registered User
    Join Date
    12-02-2017
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    55

    How to delete pictures without deleting other objects?

    I'm having a sheet with 2 ActiveX comboboxes that needs to stay, while deleting a picture that changes from time to time.

    Everything I've tried so far either deletes all objects, included my comboboxes, or just removes one of the comboboxes for some reason. And since the picture will change its name will too, so can't just say delete picture x.

    The comboboxes are placed at A1 and A2, and the picture is placed around I:V. I've tried to find special in the I:V range too in the hopes that it would ignore the comboboxes, but this isn't the case.

    Is it possible, or will I have to delete the picture manually every time?

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: How to delete pictures without deleting other objects?

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    12-02-2017
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    55

    Re: How to delete pictures without deleting other objects?

    Quote Originally Posted by AlphaFrog View Post
    Please Login or Register  to view this content.
    That was almost embarassingly easy :D I just changed to (1) to (3) and that was it. Thank you. I'll mark as solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro Is Deleting all Pictures and ActiveX Objects
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 01:26 PM
  2. automatically update excel linked pictures/objects
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2014, 07:38 AM
  3. Insert/Delete Multiple Pictures but 1 or more pictures not available
    By MrNoodles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 02:10 PM
  4. Pictures (Objects?) visible based on cell values
    By BrettW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2010, 12:31 AM
  5. How to make objects or pictures not selectable?
    By frittob in forum Excel General
    Replies: 1
    Last Post: 04-23-2009, 04:39 AM
  6. Replies: 0
    Last Post: 04-22-2008, 07:17 PM
  7. [SOLVED] Excel's Compress Pictures or deleting pictures doesn't seem work
    By guidod in forum Excel General
    Replies: 1
    Last Post: 01-29-2006, 02:50 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1