formatting

[jstp]

I've created a macro that will update font color based on content of a field
using Active Selection. I would like it to update at the time of data entry.
Thanks for your help.

 

[JackD]

You will need to make it run using the ProjectBeforeTaskChange event.
Details on how to do this are at my website here:
http://masamiki.com/project/project_open.htm

 

[jstp]

Thanks, Jack. I'm having a difficult time getting it to call the macro. Any
ideas?

Thanks again.

 

[JackD]

What do you mean by a difficult time?
Did you follow all the steps?
Perhaps the changes you are making are not triggering the event (that can
happen)
Perhaps the macro is running but not working correctly.
There are many possible causes so some more detail (including the code you
are using) would be helpful.

 

[jstp]

This is a portion of the code. I'm receiving an error that "select row" and
"active selection" are not available. I'm attempting to select the entire row
and change the font color

Private Sub App_ProjectBeforeTaskChange(ByVal tsk As Task, _
ByVal Field As PjField, ByVal NewVal As Variant, _
Cancel As Boolean)

If Field = pjTaskPercentComplete And NewVal = "100" Then
SelectRow Row:=0
ActiveSelection.Tasks.Application.Font Color:=11
Cancel = False
End If


End Sub

 

[JackD]

I'd think it might be not understanding what the active task is at that
time, so perhaps you could retrieve the task ID and use it to make the
selection?