Your Personal Assistant: Project can remind the tasks due this week


In my earliest post, you learnt how to write event procedures for Project and Application object. In this post, 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
image12.png?w=640

2. In the editor, double click your current project on the left panel.

3. Now change the object and procedure to "Project" and "Open".

4. This will include a private sub-routine which will be invoked when the file is opened

5. Within this sub-routine, include the below script

6. Close the editor, and close the project

Open the project file, and Project will highlight the incomplete tasks that should be completed by this week.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s