Se connecter
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Levelling Event? MSP 2007

Answered Levelling Event? MSP 2007

  • mardi 24 juillet 2012 13:26
     
     
    Connectez-vous pour voter
    0

    Hi Guys

    We have a slight issue with some plans occasionally levelling tasks.  In an effort to track it down I'd like to run a small piece of code to trap the event.  My only issue is I don't know if there is even an "On Levelling" event I can use.

    If anyone knows of an event I could use I'd appreciate it.

    John.

     

Toutes les réponses

  • jeudi 26 juillet 2012 06:55
     
     
    Connectez-vous pour voter
    0

    Hi John,

    Please see the below two events that should help.

    Application.ProjectBeforeTaskChange2
    http://msdn.microsoft.com/en-us/library/office/ff860391.aspx
    Application.ProjectBeforeTaskChange
    http://msdn.microsoft.com/en-us/library/office/ff865521.aspx

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

     
  • jeudi 26 juillet 2012 09:04
    Modérateur
     
     Traitée
    Connectez-vous pour voter
    0

    There isn't a leveling event. The Change events Amit suggests can't tell you if the event was caused by a leveling change or a manual edit. Project shouldn't change anything provided leveling is set to Manual (the default).

    What version of Project do you have and what Service Pack level?

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    • Marqué comme réponse JohnHolding mardi 31 juillet 2012 09:21
    •  
     
  • jeudi 26 juillet 2012 09:15
     
     
    Connectez-vous pour voter
    0
    Thanks Rod for correcting :)
    Another way to have a button on ribbon to do a leveling & call the levelNow method to trap the ProjectBeforeTaskChange2 event? Will that work?

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

     
  • jeudi 26 juillet 2012 11:56
    Modérateur
     
     
    Connectez-vous pour voter
    0

    Hi Amid and all,

    I recommend indeed setting a button on a ribbon to call a macro that calls LevelNow.

    When you teach the user to only use leveling through that button you do  not need an event since your macro is active when leveling is called like this.

    I agree with Rod that there is no event specifically linked to leveling and the beforetaskchange events react to each and every editing or change!

    Greetings,

     
  • mardi 31 juillet 2012 09:21
     
     
    Connectez-vous pour voter
    0

    Hi Rod, Amit and Jan

    Sorry for the delayed response, I've had my nose deep in Project trying to sort some other issues out.

    The levelling issue we are having seems to be an automatic function, even though levelling is set to manual, something somewhere is levelling out some but not all tasks.

    We are using Project 2007 with sp3 at the moment.

    I was rather hoping there was a levelling event I could use to at least help diagnose what is happening, but if not then I can be a little more heavy handed with it.  Working out an algorythm base on timephased data to detect repeating values won't be perfect, but it will at least help us detect any occurances.

    John.