Macro to collapse Reocurring Tasks

S

Steve

I have a project with multiple inserted reocurring tasks for meeting etc.,
spaced it the project. In updating the file, I have to expand all and do the
update. Can any one suggest a macro I could run that would close (collapse)
the inserted reocurring tasks before I send it to the printer and find I
missed a couple of them and have to reprint it again.
Thank, Steve
 
J

John

Steve said:
I have a project with multiple inserted reocurring tasks for meeting etc.,
spaced it the project. In updating the file, I have to expand all and do the
update. Can any one suggest a macro I could run that would close (collapse)
the inserted reocurring tasks before I send it to the printer and find I
missed a couple of them and have to reprint it again.
Thank, Steve

Steve,
A simple macro could certainly be created but I've got a much better
idea. Create a simple filter that looks for a "yes" in the Recurring
field. Then collapse or expand the tasks as necessary.

John
Project MVP
 
J

Jan De Messemaeker

Hi,

How about

sub close_recurring
dim anytask as task
for each anytask in activeproject.tasks
if not anytask is nothing then
if anytask.recurring and anytask.summary then
anytask.outlinehidesubtasks
end if
end if
next anytask
end sub

HTH
 
S

Steve

Thank you all! The simple filter works, I'll try my hand at the macro to
make it more hands free. Again, many thanks. Steve
 
J

John

Steve said:
Thank you all! The simple filter works, I'll try my hand at the macro to
make it more hands free. Again, many thanks. Steve

Steve,
You're welcome.

John
 

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

Top