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.
help...I don't want to do 2 steps.
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,
each
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
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:
foreach
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"
forHello 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] >
eachtheanytask 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
barstyle..
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
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:
foreach
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
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.