Back to ArticlesBack

Join 500,000+ PM Professionals

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

MPUG

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 500,000+ PMs receiving updates on the latest PM methodologies, PDU opportunities, tool reviews, career tips, and member exclusives.

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

© 2025 MPUG. All rights reserved.

TermsPrivacySitemap
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
•almost 11 years 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

Two Project Manager Agent Features You Might Like
Articles
5 min read

Two Project Manager Agent Features You Might Like

Discover two game-changing features of Microsoft’s Project Manager Agent including agent-to-agent communication and the new integrated interface in Planner.

E
Erik van Hurck
about 1 month ago
Read
Master Dependency Analysis in Microsoft Project with SSI Tools!
Articles
2 min read

Master Dependency Analysis in Microsoft Project with SSI Tools!

Learn how to master dependency analysis in Microsoft Project using SSI Tools’ Directional Path, Connecting Path, and Dependency Tracer to analyze predecessors, successors, and project logic.

K
Kenny Arnold
about 2 months ago
Read
A PM’s Halloween Survival Guide
Articles
5 min read

A PM’s Halloween Survival Guide

Discover the spooky parallels between Halloween and project management, from scope creep monsters to ghosted team members, in this fun survival guide for PMs.

R
Ronald B. Smith, MBA, PMP
2 months ago
Read
Explore All Articles