cwabbit99 said:
I'm attempting to track multiple subprojects in one master project. The only
connection is that the projects are for the same client. I'd like to track
each in a different color so they can all be on the same calendar. Does
anyone know how to do this?
cwabbit99,
I'm lost with your statement about color and calendar. The only part
that does make some sense is client and color.
Something that you should be aware of is that in a master file the
visual presentation is unique to the master. In other words, if you set
all tasks in subproject "A" to have a blue font, that subproject will
NOT show up in a blue font when viewed in a master file. Although this
is true for text data, formulas are a different story (see below).
If you want to color code the subproject by client there are a couple of
ways to do it. One fairly easy way is to designate a spare field in each
subproject as a custom field and use graphical indicators to set a color
based on client. Note these custom indicators must be set in the
individual subproject files. When viewed in the master this custom field
will be color coded to indicate the client. Granted this approach will
not change the font color but it will give a visual color indication at
the master level.
In order to do exactly what you want, (i.e. use font colors to indicate
which subprojects belong to which client), you will need to use VBA, or
manually set the font color in the master. In VBA pseudo code, a spare
field (e.g. Text1) would be used to indicate the client by name, number
or whatever. A VBA macro in the master would then "read" this spare
field and change the task font colors accordingly. It's not all that
difficult but I'm not sure it is really worth the effort.
John
Project MVP
