highlighting project tasks

L

Lynn

Hi,

I would like to write a vba code to highlight tasks that has been
overdued for 1 week in RED.


any help here?


thanks in advance
 
J

Jack Dahlgren MVP

Do you want the bar to turn red or the task name?
Either is possible. Is "overdue" just related to the finish date or would
you want it to pick up tasks that should have started?

-Jack Dahlgren

Hi,

I would like to write a vba code to highlight tasks that has been
overdued for 1 week in RED.

any help here?

thanks in advance
Click to expand...


any help?
 
R

Rod Gill

If this is for a report only, try creating a filter for the tasks you want
in red, then in Project,Filter, More Filters, apply but Highlight all
matching tasks. Then Format, Text Styles and set the Highlight format to be
what you want.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



I want the task name to turn red
"overdue" just related to the finish date
 
L

Lynn

This is not for reporting.
I want to have a view of all tasks in the project. highlighted in red
are overdue tasks, blue are tasks that are yet to be started etc....

So I am thinking only way is to have a macro for it
 
R

Rod Gill

A macro will do this, but you will need to run it whenever you want the font
colors updated.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



This is not for reporting.
I want to have a view of all tasks in the project. highlighted in red
are overdue tasks, blue are tasks that are yet to be started etc....

So I am thinking only way is to have a macro for it
 
L

Lynn

I am ok the run it only when i need it. Question is how to write this
macro? any reference?
 
R

Rod Gill

Start by recording a macro of you doing this manually, then insert the
recorded code into a loop for all tasks

Dim Tsk as Task
For Each Tsk in ActiveProject.Tasks
if not tsk is nothing then
Recorded code modified to use Tsk as the current task
End If
Next

My book will also help!!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



I am ok the run it only when i need it. Question is how to write this
macro? any reference?
 
L

Lynn

how does it test for overdue date?

Start by recording a macro of you doing this manually, then insert the
recorded code into a loop for all tasks

Dim Tsk as Task
    For Each Tsk in ActiveProject.Tasks
        if not tsk is nothing then
            Recorded code modified to use Tsk as the current task
        End If
    Next

My book will also help!!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com


I am ok the run it only when i need it. Question is how to write this
macro? any reference?









- Show quoted text -
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Status of predecessors Task 0
Clicking link tasks again increases duration 0
highlighting project tasks 7
Remove checked items from To Do lists 0
How do I convert shading to highlighting for specific colors 8
Making "Change Highlighting" feature darker 1
Highlighting text in PPT 2010 0

Top