Results 1 to 4 of 4

Enable a Macro only when there are Entries in Two Cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Enable a Macro only when there are Entries in Two Cells

    I have a button (Shape) which when clicked runs a macro. I'd like this to be disabled and greyed out until there are entries in two cells (see attached sample). When there are entries in both cells, the button's format should change and allow the macro to run when clicked.

    Is there any way to achieve this?

    Many thanks
    Thanks,
    HangMan

    You can say "Thank you!" by clicking Add Reputation below the post.
    Please, mark your thread [SOLVED] if you are happy with the solution.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-29-2015, 12:36 PM
  2. [SOLVED] Is it mandatory to keep the excel file as macro enable (if inside having macro) ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2014, 11:39 PM
  3. macro to open excel file with auto macro enable
    By jamewoong in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-14-2014, 10:44 AM
  4. Replies: 0
    Last Post: 08-06-2013, 08:21 AM
  5. Big challenge: protect multiple sheets AND enable outlining AND enable insert comment
    By visschercaravelle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-23-2010, 11:46 AM
  6. Macro to automatically fill cells based on previous entries
    By jerinjan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2008, 08:13 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