Loading...
Quick Links

Your Personal Assistant: Highlight Tasks Due this Week

In this article, I will focus on a very simple tip – How to highlight the tasks due this week every time the project plan is opened.

Looks very simple and it is indeed, very simple!

  1. Click View tab. Click Macros dropdown and select Visual Basic
    highlight tasks_1
  2. In the editor, double click your current project on the left panel.
  3. Now change the object and procedure to “Project” and “Open”.
    highlight tasks_2
  4. This will include a private sub-routine which will be invoked when the file is opened
    highlight tasks_3
  5. Within this sub-routine, include the below script
    highlight tasks_4
  6. Close the editor, and close the project
  7. Open the project file, and Project will highlight the incomplete tasks that should be completed by this week.highlight tasks_5

 

 

Sai Prasad
Written by Sai Prasad

B Sai Prasad, PMP®, PMI-SP®, MVP Project, Senior Manager – Learning & Development, has been with service provider Cognizant Technology Solutions India Pvt. Ltd since 2001 where he was named winner of the company’s Global Trainer of the Year award. He has spent 13,000-plus hours in mentoring, coaching, training 9000-plus practitioners on project management topics ranging from project management concepts, project risk management, project scheduling, Microsoft Office Project® to software estimation techniques.

He is a Champion of Project Management from PMI India and also Associate Champion Advisory Committee, PMI India. He is awarded the Champion of the Quarter (Q4 – 2012) and Delivery Excellence Award (2011-2012, 2012-2013) from PMI India. He’s also the editor of the project management book, Forecast Scheduling with Project 2010. He is a Microsoft Certified Technology Specialist (MCTS) in Project 2010. He is the President of the MPUG India Chennai chapter to promote and help practitioners on how to effectively use Microsoft Office Project.

Share This Post
16 Comments
  1. Hi, I tried using your tip, but I get a run-time error ‘1101’.. The filter “tasks Due This Week” cannot be found. I am using MS Project 2010.

    Thanks,

    Reply
  2. Sai Prasad

    Claudio Boselli – This filter is available in Project 2013 and not in earlier versions.

    Reply
  3. That’s a good example of a simple VB routine, Sai. I’d be interested in more such examples.

    Without using VB, seems nearly as simple to create a custom filter through the “new” filter menu, with the filter prompting the user for the “due by” date? If one really wanted to apply the filter every time project opened, one could make the view in which the filter is applied the default view.

    Reply
  4. What is the filter criteria for “Tasks Due This Week”?

    I also have MS Proj 2010. By creating my own filter, I should be able to run the above macro.

    Thanks.

    Reply
  5. Sai Prasad

    Fred – Project 2013 supports predefined filtered values constrants and this is used in this filter definition. Embedded the screenshot of “Tasks Due This Week” filter definition

    Reply
  6. Sai Prasad

    Tasks Due This Week filter definition – http://i.imgur.com/fHzhZVL.png

    Reply
  7. Sai Prasad

    Tim – Good thought. Care should be taken by user to applying the “Tasks Due This Week” filter before closing the file otherwise the last applied filter will be used the next time the file is opened

    Reply
  8. I too had the filter “tasks Due This Week” cannot be found and am using MS Project 2010.

    It would be appreciated of there is a similar way to do this in 2010.

    Reply
  9. This is absolutely the most helpful tip I’ve EVER seen on MPUG. Thank you very much!!!! Please post more. 🙂

    Reply
  10. I applied the tip and it works. Thanks.

    Reply
  11. Sai Prasad

    Fred and Hirish – In Project 2010 you need create a few custom fields and filter to make this work. Here are the steps
    1. Find the week start of the current date: In Gantt Chart, insert the Date1. Right click the column and choose Custom Fields. See this screenshot to rename and apply the formula. http://i.imgur.com/kSUNHhq.png
    2. Find the week end of the current date: In Gantt Chart, insert the Date2. Right click the column and choose Custom Fields. See this screenshot to rename and apply the formula. http://i.imgur.com/X3Or1YY.png
    3. Create a filter “Tasks Due This Week”. In View ribbon, select Filter dropdown and click New Filter. In Filter Definition dialog box, enter the formula to check if the current finish date is between Date1 and Date2. See this screenshot for details http://i.imgur.com/oT93UUB.png

    Reply
  12. Sai, I assume that for the “week end” calculated field, you can replace the “7” with any number and the macro would still function. (i.e. you can use this to make a 2-week look ahead, 30-day look ahead, etc)

    Reply
  13. Sai, one additional question? How would the macro need to be changed to support using the Baseline Start/Finish vs the Early Start/Finish? Folks might want to highlight those actions that need greatest emphasis to attempt to get back on track if behind schedule.

    Reply
  14. Sai Prasad

    Devin – yes, you can replace 7 by 14 for two wee!s forecast or 30 for 30 days forecast.

    Reply
  15. Sai Prasad

    Devin – Project includes a filter “Slipping Tasks”. This checks if finish is past the baseline finish. So, you can change filter name in this macro to ” Slipping Tasks”

    Reply
  16. Excellent tip, Sai!!! Thank you so much!!!

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

Thanks for submitting your comment!
You must be logged in to comment.