+ Reply to Thread
Results 1 to 5 of 5

Hide command button, based on cell value when linked to another sheet?

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Hide command button, based on cell value when linked to another sheet?

    Please could someone help me with below code, essentially it hides two command buttons if a value in a cell is over 183.

    It works when I type a number into the cell (K4), but its going to be linked to another cell on another sheet, so it contains the formula ='3'!$L$3.

    Doesn't work when it's sent up this way? Code below.

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Hide command button, based on cell value when linked to another sheet?

    You could use the Calculate event instead, as the Worksheet Change event is not triggered by a formula changing.

  3. #3
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Re: Hide command button, based on cell value when linked to another sheet?

    What would the code be? Sorry beginner in VBA.

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Hide command button, based on cell value when linked to another sheet?

    Try this:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Re: Hide command button, based on cell value when linked to another sheet?

    Works great, thank you.

+ 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. [SOLVED] Hide Option Button based on Linked Cell Value
    By slinn727 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-21-2015, 01:41 PM
  2. Command Button - Hide and Unhide Sheet VBA
    By Kimber20 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2014, 11:06 AM
  3. [SOLVED] ‘How to hide command button based on another cell - Additional buttons?’
    By tittbb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2014, 10:49 PM
  4. How to hide command button based on another cell?
    By proepert in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-27-2014, 09:28 AM
  5. Hide/Unhide Command Button based on multiple cell values
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2011, 09:03 PM
  6. [SOLVED] Hide/Show Command button based on cell value
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2010, 08:59 AM
  7. [SOLVED] How do I hide a command button based on a condition?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2006, 09:50 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