none
Levelling Event? MSP 2007 RRS feed

  • Question

  • 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.

    Tuesday, July 24, 2012 1:26 PM

Answers

All replies

  • 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

    Thursday, July 26, 2012 6:55 AM
  • 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

    • Marked as answer by JohnHolding Tuesday, July 31, 2012 9:21 AM
    Thursday, July 26, 2012 9:04 AM
    Moderator
  • 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

    Thursday, July 26, 2012 9:15 AM
  • 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,

    Thursday, July 26, 2012 11:56 AM
    Moderator
  • 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.

    Tuesday, July 31, 2012 9:21 AM