view only tasks with predecessors completed

[yomtov]

Is there a way to customize a view so that only the tasks that the
predecessors have been completed show up?

In the same token is there a view where only tasks that have predecessors
show up?

I am using MS Project 2007

Thanks in advance.

 

[Rod Gill]

Hi,

You will need to write some VBA to set a flag for any task with completed
predecessors. However for all tasks with predecessors, create a filter where
the predecessors task is not blank.

--

Rod Gill
Microsoft MVP for Project

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

 

[yomtov]

Thanks

It is incredible that such a simple view is not available as part of
Project. I would think that this is quite a common viewing requirement for
many projects. I know it is for me.

 

[Rod Gill]

Everyone works in different ways. I'm more interested in tasks that have no
predecessors and tasks that are incomplete and have never heard a request
for predecessors that are complete! Project provides Views for many things,
but obviously not everything.

--

Rod Gill
Microsoft MVP for Project

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

 

[Jan De Messemaeker]

Hi,

BTW here is the VBA code that sets Flag1 to yes for tasks with no incomplete
predecessorss:

Sub OnlyComplete
dim Job as task
Dim Pred as task
for each job in activeproject.tasks
if not job is nothing then
job.flag1=true
for each pred in job.predecessortasks
if not pred.percentcomplete=100 then
job.flag1=false
exit for
next pred
end if 'nothing
end sub

Fellow MVP Jack Dahlgeen explains on http://www.masmiki.com how to
implement VBA code

Hope this helps,



--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[yomtov]

Thank you. I will see if I can do this VBA code.

BTW, the link below to Jack Dahlgeen does not work. Do you have an updated
link?

 

[Jan De Messemaeker]

Sorry! it is www.masamiki.com
typing error, this time I checked.
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[yomtov]

Thank you. This is very helpful.

Sorry! it is www.masamiki.com
typing error, this time I checked.
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[yomtov]

Hi Jan,

The site you sent me was very good, thank you. I was able to find a code
there that was exactly what i needed, and I was also able to figure out how
to install the macro into the project without any prior knowledge.

However when I tried your macro that you include here an error pops up,
something that "For needs Next" or "Next deeds For". Can you look if there
is some mistake in the code?

Also,do you know how I can filter to view only the lowest level tasks?
These are the only ones that require action.