+ Reply to Thread
Results 1 to 10 of 10

Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    22

    Question Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    I've looked all over this board and found a bunch of solutions, but none that do exactly what I'm looking for and none that actually worked.
    I'm using this as a Project Management Task Tracking tool.

    I need to button to toggle hide/view done tasks. Column B is where I check a task as done. I use the Marlet font so when I type the letter 'a' in cell, it looks like a check mark.
    Resolving that issue alone would be great!

    Ideally, I would also like to set a range of rows for this. I have multiple tables on that page, one table for each project, and I add rows often, and since row on top of each table is the name of project, I can't just select the entire B column.
    If this can't be done I'll split them across sheets, but it would be awesome if it could.

    Thanks.

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    whoa... this is really hard to see in my head from your description.




    Can you upload an example?
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    01-02-2014
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    PM Task Tracking.xlsm

    Oops, sorry about that. Here it is.

    Thank you!!!

  4. #4
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    Quote Originally Posted by The Phoenix View Post
    Ideally, I would also like to set a range of rows for this. I have multiple tables on that page, one table for each project, and I add rows often, and since row on top of each table is the name of project, I can't just select the entire B column.

    What exactly do you mean? Are you having problems due to merged cells (by any chance)?

  5. #5
    Registered User
    Join Date
    01-02-2014
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    No. I don't know how to do any of it. Tried using some of the code I found on this site, but there are none I could find that would have 1 button to toggle view/hide rows based on what is in a cell.

  6. #6
    Registered User
    Join Date
    01-02-2014
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    Anyone? Please help!

  7. #7
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    Ok, NOW I see what you mean... noticed you have macros in place now

    This appears to work just fine


    Please Login or Register  to view this content.

    I would think your UNHIDE Rows would just be this:

    Please Login or Register  to view this content.


    EDIT:

    BTW, I put that merged cell check in there because you mentioned it earlier... but that doesn't actually hamper looking at the entire column. ALSO! I forgot to mention I refer the your sheet by code name w_toDOList (see attached).
    Attached Files Attached Files
    Last edited by GeneralDisarray; 07-09-2015 at 05:00 PM.

  8. #8
    Registered User
    Join Date
    01-02-2014
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    Thank you, though I'm a bit confused. When I create a button, I see a bunch of macros. Which one should I assign to allow to hide and unhide rows by clicking it?
    What I'm trying to do is have one button that says 'Hide Done' and when I click on it, all done rows become hidden and that same button now says 'Unhide Done'. Clicking on it would bring back all done rows.

    So sorry about that, I'm not sure I was very clear in my original description. Can you help?

  9. #9
    Registered User
    Join Date
    01-02-2014
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    Can anyone please help?

  10. #10
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows

    Ok, I guess I left that out - your attachment had some macros in place already, I just added my own into your 'module 2'.

    I assigned the macros to the buttons added (actually, my buttons are just shapes).

    General steps for this: Make macro, Insert shape in worksheet, right click on shape, select assign macro, then pick the macro you want the shape to launch when clicked on.

    See attached:
    Attached Files Attached Files

+ 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] Toggle Button to hide/unhide rows based on value
    By goomblar in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-03-2014, 07:35 AM
  2. [SOLVED] Macro to toggle between hide/unhide rows
    By fpt264 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2014, 04:30 PM
  3. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  4. Macro to toggle between Hide and Unhide rows
    By fpt264 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-14-2013, 01:47 PM
  5. Using Toggle Button to hide/unhide rows that may change
    By jmpatrick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2011, 09:48 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