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 - Master Project User Group

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 Glossary

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUG Logo

© 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 3 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

The Toilet Paper Rule: Why Small Problems Become Big Failures
Articles
1 min read

The Toilet Paper Rule: Why Small Problems Become Big Failures

Ronald B. Smith uses the humble toilet paper roll to unpack six enduring truths about preparation, quality, and the invisible work of project management.

A
Anonymous
4 days ago
Read
Are You Running a Risk Meeting or a Risk Workshop?
Articles
1 min read

Are You Running a Risk Meeting or a Risk Workshop?

Learn the difference between a risk meeting and a risk workshop, and why structured risk workshops help project teams identify owners, define actions, and protect project outcomes.

A
Anonymous
11 days ago
Read
“I Need a Dashboard by Friday” – How AI Just Made That Possible
Articles
1 min read

“I Need a Dashboard by Friday” – How AI Just Made That Possible

Need a dashboard by Friday? Discover how AI tools like ChatGPT can help you build an Excel dashboard quickly and easily—no advanced technical skills required. Learn how to turn plain-English requests into real, working reports with spreadsheets that actually work for you.

A
Anonymous
11 days ago
Read
Explore All Articles