Task Field As Objects

S

Steve

Stephen Sanderlin said:
We need more information. What language? What context? What are you
trying to do?
Click to expand...

Im working in VBA. I have a macro the will color the background cell color
of the Finish Variance cell based on some time frame parameters. If I can, I
want to make the code run on a single Finish Variance cell when that cell
value changes. So I would need to make Finish Variance an object so I can
write the code to a FinishVariance_Change() event
 
S

Stephen Sanderlin

My suggestion would be to write a handler for the
ProjectBeforeTaskChange2() event (and/or
ProjectBeforeAssignmentChange2() event, depending on your needs). Note
that there are some known issues with the ProjectBeforeTaskChange() and
ProjectBeforeTaskChange2() events before the January 28th 2008 hotfix.

HTH,
Steve

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com
 
S

Steve

Stephen Sanderlin said:
My suggestion would be to write a handler for the
ProjectBeforeTaskChange2() event (and/or
ProjectBeforeAssignmentChange2() event, depending on your needs). Note
that there are some known issues with the ProjectBeforeTaskChange() and
ProjectBeforeTaskChange2() events before the January 28th 2008 hotfix.

HTH,
Steve
Click to expand...
Thanks for the help. I've got one more question; it says that
Project_BeforeTaskChange() does not work on a project that is embedded in
another project. I use a Master Project with lots of little embedded
projects. To counter that, can I write the code on the Master? Because I am
reading the remark on the help file as meaning the code will not execute on
the subproject if the code is only written on the subproject. Or am I reading
it wrong and what it is telling me is that there is no way for the event to
work on a subproject?
Thanks a lot.
 
S

Stephen Sanderlin

I haven't ever tried to do this with subprojects before, so I'm not
sure. Specifically, the documentation says that "Microsoft Office
Project 2007 events do not occur when the project is embedded in another
document or application" and that this particular event doesn't work
"when inserting or removing a subproject". I would interpret the first
statement as meaning that a project embedded in, for example, a Word
file will not fire Project events. I do not necessarily know if we can
infer that it will not work for any changes in a subproject (except for
obviously insert or remove operations on a subproject). The only thing I
can suggest is to try it (or maybe Rod knows).

If you do decide to try it, please let us know if it worked for a
subproject or not.

Regards,
Steve

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com
 
Top