Formatting & Printing Questions

[sunrhat]

Hi All,

I've got two questions I couldn't find answers to in the help menu:

1. Is there a way to assign a font color to a resource name and also t
their Gantt bar so that it's automatic whenever I choose that resourc
name from the drop-down menu?

2. In Gantt chart view, if I have 6 columns such as text1, Name, Start
Finish, Duration, Resource, is there a way to just print one of th
columns (Name) OTHER than hiding the rest? I'm looking for a shortcu
to hide and unhide columns but the macro I recorded had problems
couldn't fix (slowly learning VBA for Dummies - too slowly).

Thanks in advance,
Kat

 

[John]

Hi All,

I've got two questions I couldn't find answers to in the help menu:

1. Is there a way to assign a font color to a resource name and also to
their Gantt bar so that it's automatic whenever I choose that resource
name from the drop-down menu?

2. In Gantt chart view, if I have 6 columns such as text1, Name, Start,
Finish, Duration, Resource, is there a way to just print one of the
columns (Name) OTHER than hiding the rest? I'm looking for a shortcut
to hide and unhide columns but the macro I recorded had problems I
couldn't fix (slowly learning VBA for Dummies - too slowly).

Thanks in advance,
Kate

Kate,
1. First of all, resources do not have Gantt bars, tasks do. However,
not to throw cold water on your idea, you can set up a customized field
with a formula that sets a flag for those tasks that have the resource
of interest assigned. Use the InStr function in the formula to find out
if the resource exists in the Resource Names field. Then set up a
special Gantt bar color for tasks where the flag is true. Be advised
however that this will only work for tasks that have single resource
assignments.

2. You could set up six custom views with just the fields of interest
and then print whichever view you want. That's gotta be easier than
tweaking the existing view each time. The other option is to hone your
VBA skills further. Along that line, did I recommend to you previously
the Project VBA book by fellow MVP, Rod Gill? If not you can find out
more information at:
http://www.projectvbabook.com

Hope this helps.
John
Project MVP