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