Results 1 to 6 of 6

Macros assigned Shape, colour changing code needed please

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Macros assigned Shape, colour changing code needed please

    I have made several Shapes and assigned macros to them, all is good.

    What i am curious about: is it possible to highlight or change colour of the shape on press and return to normal if another is shape is pressed? Just anything to make that particular shape stand out that it has been selected then return to normal when another shape has been selected...
    Sub AllLocal()
    '
    ' AllLocal Macro
    '
        Application.ScreenUpdating = False
    '
        Sheets("DATA2").Select
        Range("A2").Select
        Selection.Copy
        Sheets("Main").Select
        Range("H5").Select
        ActiveSheet.Paste
        Range("C6").Select
        Application.ScreenUpdating = True
        
    End Sub
    That is the code so far that is attached to 1x shape...
    Last edited by lcartwright; 03-13-2014 at 08:58 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically bringing a Shape into a Cell Using Shape Code
    By dineshtendulkar in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-16-2016, 02:25 PM
  2. Finding selected shape through code
    By DeyAgahi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2013, 01:14 AM
  3. [SOLVED] Insert Excel Shape at Active Cell - Final help needed Please
    By PeterF in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-29-2012, 01:27 PM
  4. Conditional formatting needed for shape colour - is programming needed?
    By Farmboyuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 07:27 AM
  5. help needed trying to find autoshape/shape name
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2006, 11:10 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