Results 1 to 22 of 22

hiding unhiding rows macro hierarchy

Threaded View

dgibney hiding unhiding rows macro... 09-29-2014, 06:35 PM
natefarm Re: hiding unhiding rows... 09-30-2014, 05:56 PM
dgibney Re: hiding unhiding rows... 09-30-2014, 06:14 PM
natefarm Re: hiding unhiding rows... 10-03-2014, 05:29 PM
dgibney Re: hiding unhiding rows... 10-03-2014, 06:53 PM
natefarm Re: hiding unhiding rows... 10-06-2014, 09:33 AM
dgibney Re: hiding unhiding rows... 10-06-2014, 10:25 AM
natefarm Re: hiding unhiding rows... 10-06-2014, 03:57 PM
dgibney Re: hiding unhiding rows... 11-07-2014, 05:31 PM
dgibney Re: hiding unhiding rows... 11-07-2014, 05:33 PM
natefarm Re: hiding unhiding rows... 10-06-2014, 11:26 AM
dgibney Re: hiding unhiding rows... 10-07-2014, 05:37 PM
natefarm Re: hiding unhiding rows... 11-07-2014, 06:23 PM
dgibney Re: hiding unhiding rows... 11-07-2014, 06:30 PM
natefarm Re: hiding unhiding rows... 11-07-2014, 06:34 PM
natefarm Re: hiding unhiding rows... 11-10-2014, 11:22 AM
dgibney Re: hiding unhiding rows... 11-17-2014, 07:19 PM
natefarm Re: hiding unhiding rows... 11-18-2014, 12:19 PM
dgibney Re: hiding unhiding rows... 11-18-2014, 02:36 PM
natefarm Re: hiding unhiding rows... 11-18-2014, 03:10 PM
dgibney Re: hiding unhiding rows... 11-18-2014, 07:03 PM
natefarm Re: hiding unhiding rows... 11-19-2014, 01:44 PM
  1. #1
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    hiding unhiding rows macro hierarchy

    Depending on which goals are selected from pull-down menus in the “Goals” sheet this tool creates customized task lists by hiding or unhiding rows in the “Tasks” sheet. By selecting a button team members can sort their own tasks if a value (labor hours) has been entered into the appropriate task row and beneath their column. By pushing this button again all tasks and all team members columns are unhidden.
    PROBLEM: how to keep rows hidden or unhidden based on the selection in the pull-down menu in the “Goals” sheet. Please see attached document.The command to unhide all tasks unfortunately unhides all rows, including those that are hidden. Is there a line of code I can enter into the “DocTasksOnly” macro that will direct it to ignore hidden rows? Or, once the task list is filtered for a team member, is there a way to auto-refresh the hiding/unhiding of task rows? By selecting different goals and toggling the button back and forth you will better be able to understand the dilemma I've got myself into...
    Note that hiding/unhiding macros are provided only for “Doc” in this file example. In the final these macros will be replicated for each team member.
    Thanks for your help! David

    "Goals" code:
    HTML Code: 
    "Tasks" sheet code:
    HTML Code: 
    "Hide_Unhide_Task_RowsColumns" code:
    HTML Code: 
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hiding/Unhiding rows
    By cool53 in forum Excel General
    Replies: 8
    Last Post: 10-25-2013, 02:31 AM
  2. [SOLVED] Hiding/Unhiding Rows
    By marcheese in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-26-2012, 10:25 AM
  3. Hiding/Unhiding Rows
    By marcheese in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2012, 11:56 PM
  4. Hiding and unhiding rows
    By Ranjani in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2009, 02:37 AM
  5. Hiding/Unhiding rows
    By Arne Hegefors in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2006, 03:25 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