+ Reply to Thread
Results 1 to 4 of 4

(VBA) Delete All Shape in Worksheet excerpt for the shape contain in Sheet1

  1. #1
    Registered User
    Join Date
    09-27-2018
    Location
    Malaysia
    MS-Off Ver
    MS Office 2010
    Posts
    28

    Smile (VBA) Delete All Shape in Worksheet excerpt for the shape contain in Sheet1

    Hi

    I am new to VBA. I wanted to delete all shape in workbook excerpt the shape that contained in Worksheet ("Sheet1"). The reason doing so is because i had code that split the data into multiple worksheet. when the data are split, the shape will also split to other worksheet.. is there any way to delete all the shape in all worksheet excerpt for "Sheet1"

    Thank you
    Your help will be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: (VBA) Delete All Shape in Worksheet excerpt for the shape contain in Sheet1

    Try
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    09-27-2018
    Location
    Malaysia
    MS-Off Ver
    MS Office 2010
    Posts
    28

    Re: (VBA) Delete All Shape in Worksheet excerpt for the shape contain in Sheet1

    Hi Khalil,
    wow, you are brilliant.. the code work prefectly as what i wanted
    Just curious, Why the code use drawingobject instead of shape

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: (VBA) Delete All Shape in Worksheet excerpt for the shape contain in Sheet1

    You're welcome. You can use the Shape also to do the same task

+ 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. Shape buttons - Switch background image of shape on click and exit - referenced jpg
    By ApatheticAndrew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2015, 08:06 AM
  2. Assign macro with parameter to shape based on shape location
    By bobo3127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 11:18 AM
  3. Replies: 13
    Last Post: 12-10-2013, 12:51 PM
  4. [SOLVED] Use a button to control a macro that inserts an image into a shape or resets the shape
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 04:41 PM
  5. Replies: 0
    Last Post: 11-30-2012, 01:29 PM
  6. Detect a shape in a worksheet ande delete
    By jamiguel77 in forum Excel General
    Replies: 5
    Last Post: 06-28-2012, 02:45 PM
  7. delete shape that has same shape name a cell
    By beatrice25 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2009, 03:05 AM

Tags for this Thread

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