Prevent the PM from unintentionally change the actual work

[Daniel]

Hello,
I am writing a macro using the ProjectBeforeTaskChange event in order to
prevent the project manager from unintentionally change the actual work.
Actually I am thinking about these circumstances: For a task with some actual
work, if the project manager reduces too much the task duration, it can
affect the actual work as well, and I want to avoid that.
Ex. : Let say the actual work is 10days, the duration is 20 days, if the
duration is reduce to 9 days, the actual work is reduce to 9 days as well.
The problem is: the field event is equal to pjTaskDuration and not to
pjTaskActualWork. So I am not able to catch the actual work change.
Any ideas about how I can do it?

 

[Jan De Messemaeker]

Hi,

Shouldn't you compare the new value for duration to the Actual Duration
field?
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Daniel]

Ok, I have to check if the new value for duration is less than the actual
work. I’ll do it.
So, it means that project can trigger only one event at a time, even if two
events occur at the same time? (Like pjTaskDuration and pjTaskActualWork)

 

[Rod Gill]

No. Sometimes dozens of events can be triggered which is why sometimes you
need to set a global flag so you can ignore all events after the first one.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Ok, I have to check if the new value for duration is less than the actual
work. I’ll do it.
So, it means that project can trigger only one event at a time, even if
two
events occur at the same time? (Like pjTaskDuration and pjTaskActualWork)




__________ Information from ESET Smart Security, version of virus
signature database 5061 (20100426) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5061 (20100426) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Daniel]

Thanks for your help Jan,
I tried it and it works fine.