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 5 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

Maintaining the Human Element of Leadership in a Technological World
Articles
1 min read

Maintaining the Human Element of Leadership in a Technological World

Learn how leaders can maintain humanity in technology-driven workplaces through emotional intelligence, role clarity, psychological safety, and meaningful recognition.

A
Anonymous
3 days ago
Read
5 reasons to attend: 4 pillars of Project Online to be Aware of When Migrating
Articles
1 min read

5 reasons to attend: 4 pillars of Project Online to be Aware of When Migrating

Erik van Hurck shares four pillars for a successful Project Online migration, covering scope, data prep, execution, and user adoption from real enterprise experience.

A
Anonymous
11 days ago
Read
It’s Not Unusual: Why Projects Behave Badly and Why Good PMs Expect It
Articles
1 min read

It’s Not Unusual: Why Projects Behave Badly and Why Good PMs Expect It

Projects misbehave because people behave normally — Ronald B. Smith explains why experienced PMs stop being surprised and start building systems that bend without breaking.

A
Anonymous
16 days ago
Read
Explore All Articles