+ Reply to Thread
Results 1 to 1 of 1

Change button color twice and release focus after second change

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Change button color twice and release focus after second change

    hi there,

    I have been searching th forum for help and found a code that helps me, (A BIG Thank you),however, the focus stays on the button and therefore no other cells can be selected after the code has been run. This is what I have:

    Please Login or Register  to view this content.
    The problem I am experiencing is that the focus stays on cell AX1. How do I release the spreadsheet from the code so that other cells may be selected. What I mean is that, since cell AW1 is either a 1 or a 2, the code sticks, and unless the AW1 is made anything else, no other cells can be selected. Thanks a lot guys!!

    I have tried to reply on my own post to indicate that I have sorted this out..but for reason unknown to me, my reply won't show...so..plan B..edit my original post..thanx anyways guys!!
    Last edited by juriemagic; 05-15-2014 at 04:18 AM. Reason: did not add tags..sorry guys..also i have added more code..

+ 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. change button text color
    By Martin Just in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 12:42 PM
  2. Change Button Color
    By jeff_kaufman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 02:15 PM
  3. [SOLVED] Change Background color of a Form Button or ActiveX Button
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-11-2012, 12:19 PM
  4. Change Button Color With A Macro?
    By mirtjemirtej in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2009, 04:16 PM
  5. [SOLVED] how to get my button on a for mto change color
    By Pierre in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2005, 04:45 PM

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