Validation for Project Schedule updates RRS feed

  • Question

  • Hi,

    I am working on requriement that states that a Project Schedule cannot be updated, if a Milestone in Project Schedule has already started. I am looking for alternatives for implementing this.

    Extending Event Handler (Updated) is an alternative. However, validation message cannot be displayed, if valdiation is done in Event Handler. Can this be implemented using conditional permissions? Any help in this regard will be appreciated.

    Wednesday, December 3, 2014 8:27 PM

All replies

  • Hi Abijit,

    When you say cannot be updated, do you mean you cannot amend the start, finish, duration, work fields of tasks. 

    Can you add new tasks?

    Can you update progress on existing tasks?

    Can you remove tasks?

    Please be a little more specific and someone may be able to help you.

    Ben Howard [MVP] | web | blog | book | P2O

    Wednesday, December 3, 2014 9:09 PM
  • Yes, the schedule cannot be amended. There can be no change to start, finish, duration, work and any fields for tasks in the schedule.
    Thursday, December 4, 2014 5:59 AM
  • Hi Abhijit,

    There is nothing in project that will enforce this automatically. Here are a few options you could explore. 

    1. run some VBA against the onchange event.

    2. Take a baseline when the MS has completed.  run some vba to check start, finish, duration etc against their various Baseline values at project save.

    3. If you don't want to update the schedule with %complete, put a read-only password on the project file.

    Ben Howard [MVP] | <a href="http://www.applepark.co.uk">web</a> | <a href="http://www.applepark.co.uk/ben-howard-blog"> blog</a> | <a href="http://www.microsoft.com/learning/en-us/book.aspx?id=16258&locale=en-us">book</a> | <a href="http://www.applepark.co.uk/p2o"> P2O</a>

    Thursday, December 4, 2014 6:54 AM
  • The schedule can be edited from PWA as well. The solution suggested by you would not work in that case.
    Thursday, December 4, 2014 7:41 AM
  • With the default permissions no, but you could change these.

    Ben Howard [MVP] | web | blog | book | P2O

    Thursday, December 4, 2014 7:56 AM