Color coded the specific tasks - VBA Macros

[Newbie]

I have been searching for the VBA codes, including the links from this
site. However, I could not find the answers what I have been looking.

This is not a PWA, just a Microsoft Project Professional 2007.

Situations:

1. We have already color-coded a field with "Marked". So, we can no
longer use that "marked".

2. We have one field, called -> "Level Type" (we renamed it from
"Text10"), which has three values -> "major", "minor" and "both".

3. Since we have already linked the one of the fields to the "Marked
Tasks". We could format the additional value, based on what we have
set up in the Marked tasks. (We can use it only one time.)

What we would like to do:

We like to have the VBA codes that will trigger the color coded, when
the following condition occurred:

* If the field "Level Type" (Text10) has the value of "both", we
would like to have the fonts in the "Task Name" changed to "Bold",
"Italic", "Arial", "10" with "Yellow" background. *

I tried to search for solutions. I encountered mostly with PWA issues.
There were some links that took me to the site in New Zealand that
several people recommended. When I typed the word search with the
word, "color", it did not return anything.

It is too bad that I could not find the conditional format, like we
have in Excel.

Second thing: I have never used VBA to code the Microsoft Project
Professional 2007 before. How can we ensure that the codes will be
activated? Will there be a pop-up when the file opens and ask us to
activate macros?


I do appreicate if some experts can provide the VBA codes to make this
work. Thank you for your time.

 

[Jack Dahlgren]

If you only have three values, then you can use the normal formatting, the
"marked" formatting and you have missed the third - but you can use
"Highlighted" as the third type. To highlight a task, build a filter which
looks at the value of text 10 and instead of clicking "apply" click on
"Highlight".
You will have to apply this filter when you change values of tasks from one
category to the other, but a macro would require the same.

No programming needed.

-Jack Dahlgren

 

[Newbie]

Thank you for your response.

However, the filter has already been built. We receive a big Excel
flat file on a daily basis that we would like to put the data into the
Microsoft Professional 2007 file. So, it has already screen 5,000+
tasks into 200 plus tasks.

We renamed one field to match the "marked". So, we could obtain the
correct format, bold ...arial, etc, when that value matches the
criteria. I believe that we can apply only one filter. In this case,
we have already used it.

I believe that the only way out is to write the VBA code. I do not
think I can rename that field to "highlighted", just like I renamed
the "marked", can I?

I do appreciate your response. Thank you again for assisting.

 

[Gary L. Chefetz [MVP]]

Newbie:

Check out Rod Gil's book on Project VBA. I think the downloadable code
samples will be well worth it for you. You can find the book at
http://www.projectserverbooks.com, or at your favorite bookseller including
Amazon.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com