How do I set up so that complete tasks change color?

  • Thread starter Complete tasks changing font color
  • Start date
C

Complete tasks changing font color

I can't find a way to do this in Properties or anywhere else. Please
help...I don't want to do 2 steps.
 
J

Jan De Messemaeker

Hi,

Which tasks? All tasks? The text or the bars?
Format, text style, select All then the color
PS it's nice to tell us what you don't want to do but it would be easier to
help you if you did explain what you do want to do :))

Greetings,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Complete tasks changing font color" <Complete tasks changing font
(e-mail address removed)> schreef in bericht
news:[email protected]...
 
C

Complete tasks changing font color

Hi,

I want to change all tasks once they're completed. For example when I
highlight a task in "Task Information" and fill in that it is 100% complete,
in addition to the check mark appearing to the left of the subtask, I would
like the text font to turn from black to grey.

Is this clearer?
 
J

Jan De Messemaeker

Hi,

I'm afraid you will need a little macro to do that - or use a filter

The macro would be a follows:

Sub Done_Is_Grey()

for each anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub

And in Format, Text Styles, you choose whatever font for "marked tasks"

An alternative is as follows:

View, More views, select the appropriate view, edit, check on "Highlight
filter"
Choose the desired font from Format, Text Styles, highlighted tasks.
Now when you activate the completed tasks filter they will turn to the
desired font.

HTH



--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Complete tasks changing font color"
 
J

Jan De Messemaeker

Hi,

Again, it is easier to help you when you say what you need.
You ask for the text font to turn to grey, then you decide to change the bar
style..
Greetings,
 
C

Complete tasks changing font color

Hello again,

Thanks for helping out. I've never created a macro. I copied your
suggestion as follows:

Record New Macro > Macro Name [I put "Sub Done_Is_Grey()"] > Control + A >
Store Macro in Global File > Description [I put your description] > for each
anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub
 
J

Jan De Messemaeker

Hi,

Better is
Alt+F11
select "Global.mpt" from the upper left window
Insert
Module
in the upcoming editing window paste the text

The macro is now available in Tools, Macro, Macros
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Complete tasks changing font color"
Hello again,

Thanks for helping out. I've never created a macro. I copied your
suggestion as follows:

Record New Macro > Macro Name [I put "Sub Done_Is_Grey()"] > Control + A >
Store Macro in Global File > Description [I put your description] > for each
anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub





Jan De Messemaeker said:
Hi,

Again, it is easier to help you when you say what you need.
You ask for the text font to turn to grey, then you decide to change the bar
style..
Greetings,
 
C

Complete tasks changing font color

Hi Jan,

It didn't work. I tried 2 things with your advice below (adding modules)

1st time I used the text in your example below:
for

When that didn't work, I used the text in the most recent message (b/c I
wasn't sure what you meant):
The macro is now available in Tools, Macro, Macros

This is a real pain.


Jan De Messemaeker said:
Hi,

Better is
Alt+F11
select "Global.mpt" from the upper left window
Insert
Module
in the upcoming editing window paste the text

The macro is now available in Tools, Macro, Macros
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Complete tasks changing font color"
Hello again,

Thanks for helping out. I've never created a macro. I copied your
suggestion as follows:

Record New Macro > Macro Name [I put "Sub Done_Is_Grey()"] > Control + A >
Store Macro in Global File > Description [I put your description] > for each
anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub





Jan De Messemaeker said:
Hi,

Again, it is easier to help you when you say what you need.
You ask for the text font to turn to grey, then you decide to change the bar
style..
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Cole" <[email protected]> schreef in bericht
I did Rod's way...no need for a macro if I'm understanding your
question right.

Cole
 
J

Jan De Messemaeker

Hi,
What exactly doesn't work?
Can you confirm the macro is available under Tools, Macro, Macros?
Have you pasted the code in a moduel?
If both are yes, what happens when you run the macro
Did you change the font for marked tasks in Format, Text Styles?

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Complete tasks changing font color"
Hi Jan,

It didn't work. I tried 2 things with your advice below (adding modules)

1st time I used the text in your example below:
for

When that didn't work, I used the text in the most recent message (b/c I
wasn't sure what you meant):
The macro is now available in Tools, Macro, Macros

This is a real pain.


Jan De Messemaeker said:
Hi,

Better is
Alt+F11
select "Global.mpt" from the upper left window
Insert
Module
in the upcoming editing window paste the text

The macro is now available in Tools, Macro, Macros
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Complete tasks changing font color"
Hello again,

Thanks for helping out. I've never created a macro. I copied your
suggestion as follows:

Record New Macro > Macro Name [I put "Sub Done_Is_Grey()"] > Control + A >
Store Macro in Global File > Description [I put your description] >
for
each
anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub





:

Hi,

Again, it is easier to help you when you say what you need.
You ask for the text font to turn to grey, then you decide to change
the
bar
style..
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Cole" <[email protected]> schreef in bericht
I did Rod's way...no need for a macro if I'm understanding your
question right.

Cole
 
C

Complete tasks changing font color

Jan,

1. The macro (named Sub_Done_Is_Grey) is under Tools > Macro > Macros
Exact macro text:
anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub

2. There is a module where the description says "The macro is now available
in Tools, Macro, Macros"

3. The font of marked subtasks is set for change under Format > Text Styles

4. I changed a task to 100% complete and ran the macro and nothing changed
(the font did not grey out).
Jan De Messemaeker said:
Hi,
What exactly doesn't work?
Can you confirm the macro is available under Tools, Macro, Macros?
Have you pasted the code in a moduel?
If both are yes, what happens when you run the macro
Did you change the font for marked tasks in Format, Text Styles?

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Complete tasks changing font color"
Hi Jan,

It didn't work. I tried 2 things with your advice below (adding modules)

1st time I used the text in your example below:
for
each
anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub

When that didn't work, I used the text in the most recent message (b/c I
wasn't sure what you meant):
The macro is now available in Tools, Macro, Macros

This is a real pain.


Jan De Messemaeker said:
Hi,

Better is
Alt+F11
select "Global.mpt" from the upper left window
Insert
Module
in the upcoming editing window paste the text

The macro is now available in Tools, Macro, Macros
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Complete tasks changing font color"
<[email protected]> schreef in
bericht Hello again,

Thanks for helping out. I've never created a macro. I copied your
suggestion as follows:

Record New Macro > Macro Name [I put "Sub Done_Is_Grey()"] > Control + A >
Store Macro in Global File > Description [I put your description] > for
each
anytask in activeproject.tasks
if not anytask is nothing then
anytask.marked = false
if anytask.percentcomplete=100 then
anytask.marked=true
end if
end if
next anytask
end sub





:

Hi,

Again, it is easier to help you when you say what you need.
You ask for the text font to turn to grey, then you decide to change the
bar
style..
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Cole" <[email protected]> schreef in bericht
I did Rod's way...no need for a macro if I'm understanding your
question right.

Cole
 

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