+ Reply to Thread
Results 1 to 3 of 3

followup top shapes as one colour, exclude 2 shapes

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    28

    followup top shapes as one colour, exclude 2 shapes

    HI all

    Nilem kindly helped out with a macro in the attached workbook which takes the top 5 shapes and changes their colour in a tab entitled incexc, Is it possible to expand on this code so there are 2 further shapes, one is a plus with a code to take you to another sheet, and the other I need to remain as a neutral colour. so that when the command is sent to update the shapes it will exclude the plus and minus and they will not change colour?


    Thanks,

    Ive attached the example Nilem created.

    Dean
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: followup top shapes as one colour, exclude 2 shapes

    Hi Dean,
    try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-25-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: followup top shapes as one colour, exclude 2 shapes

    You are a star Nilem ! Thanks so much !!

+ 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. format top 5 shapes as one colour and the rest as another
    By deancorleone in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2013, 09:45 AM
  2. Shapes based on Cell Data, Golf Score card data that shows shapes around scores
    By BiggDC1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2012, 12:42 PM
  3. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 PM
  4. Re: Shapes
    By Don Lloyd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2006, 06:55 PM
  5. [SOLVED] How can i get more 3D shapes for Auto shapes in excel?
    By Ajey in forum Excel General
    Replies: 0
    Last Post: 03-03-2005, 06:06 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