formatting all summary tasks using code

[ProjectUser]

Hi,
can someone please help me with VBA code that formats all summary tasks with
a certin font color (using 2003) and cell background (using 2007).

Many thanks!

 

[JulieS]

Hello ProjectUser,

I know you have asked for VBA code, but have you considered setting the
font color and background color (2007) in the Format > Text Styles
dialog box? The advantage of using the Format > Text Styles dialog box
is that if you add new summary tasks to the project they will be
automatically formatted as you need. With a macro (VBA), you'd need to
run the macro each time you change or add tasks that are summary tasks.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[ProjectUser]

Thank you for your quick response.

I have a schedule that has thousands of lines and hundreds of summary tasks.
I thought if I could run code once to perform this function of changing the
summary tasks formatting, this would be ideal. Is this possible?

Regard 2007, yes, I've used the background format. However, I'm now
getting an message that says "I've exceeded the maximum number of cells that
can be formatted...". so, I don't really know what to do here.

 

[JulieS]

Hi ProjectUser,

I think we may be talking past one another here

There is no need to run code to change the font color or background for
all summary tasks. If you choose Format > Text Styles, select Summary
out of the Items to Change drop down list, you can then select the font
color and background color for all summary tasks. This will apply to
all existing summary tasks as well as any newly added summary tasks.

Please note, it is the Format > *Text Styles* command, not the Format >
Font command.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[ProjectUser]

Thank you! Works perfectly. I didn't really this was so simple to do! You
truly are the "MVP".

Have a great day.

 

[JulieS]

You're very welcome, Project User. Thanks so much for the kind
feedback. You've made this MVP smile.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project