Back to ArticlesBack

Join 50,000+ PM Professionals

Get expert PM insights, PMP prep tips, and earn PDUs with exclusive content delivered weekly.

Protected by reCAPTCHA: Privacy & Terms

MPUG - Master Project User GroupMPUG

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

Get Weekly PM Insights

Join 50,000+ PMs receiving updates on the latest PM methodologies, PDU opportunities, tool reviews, career tips, and member exclusives.

Protected by reCAPTCHA: Privacy & Terms

PMI ATP
PMI Authorized Training Partner
REP #4082

Learning Paths

PMP® TrainingCAPM® TrainingPgMP® TrainingPMI-ACP® TrainingMS ProjectMS PlannerMS TeamsJira

PM Resources

PDU TrackerLive WebinarsSalary CalculatorTool ComparisonsJob BoardKnowledge BasePM GlossaryOur Faculty

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUGMaster Project User Group

© 2026 MPUG. All rights reserved.

TermsPrivacySitemapAdvertise
Articles

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 […]

1 min read
•over 11 years ago•Updated 8 months ago•
S
Sai PrasadAuthor
Project Management
Microsoft Project
Best Practices
Productivity
S
Sai Prasad

Content Writer

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.

View all articles by Sai Prasad
Related Content

Continue Reading

Discover more insights and articles that complement your current reading

Copilot in PowerPoint Live Now Explains Your Slides to Attendees
Articles
1 min read

Copilot in PowerPoint Live Now Explains Your Slides to Attendees

MPUG Editorial · September 7, 2026 · ~5 min read · Category: AI & Copilot Copilot in PowerPoint Live can now explain your slides to the people watching them. In […]

A
Anonymous
7 days ago
Read
Copilot Researcher Model Selection: A Small Lever With Real Effect on Project Research
Articles
1 min read

Copilot Researcher Model Selection: A Small Lever With Real Effect on Project Research

MPUG Editorial · September 8, 2026 · ~4 min read · Category: AI & Copilot Copilot Researcher model selection arrived in the Microsoft 365 Copilot release notes dated 25 August 2026, and […]

A
Anonymous
8 days ago
Read
Prompt Engineering for Project Managers
Articles
1 min read

Prompt Engineering for Project Managers

Treat AI prompts like project requirements, with three ready-to-use templates for risk analysis, executive updates, and change request tradeoffs.

A
Anonymous
9 days ago
Read
Explore All Articles