If MsgBox('This Macro will restore All Constraints for tasks that have predecessors. 'Tamzin Morphy ()- Changed = vbNo Then End (causing automation error) to = vbno Then Exit Sub 'This sets resets the tasks to have their original constraint types and dates Macro to Restore non-logic constraints 'Macro to Restore contraints that were erased by the Remove_NonLogic_Contraints() macro ProjTask.ConstraintType = 0 'Sets task to as soon as possible ProjTask.Number15 = ProjTask.ConstraintType 'Stores restore data into fields ProjTask.Date1 = ProjTask.ConstraintDate 'Stores restore data into fields If > 0 Then 'selects tasks with 1 or more dependencies ProjTask.Number15 = 0 'Clear the field we use to restore constraint type ProjTask.Date1 = '' 'Clears the field we use to restore original constraint date If ProjTask.ExternalTask = False Then 'this handles external tasks If ProjTask.Summary = False Then 'this handles summary tasks which are only allowed to be fixed duration If Not (ProjTask Is Nothing) Then 'this handles blank line in the file Do you want to continue?',įor Each ProjTask In ProjTasks 'these if statements step through all tasks in the project If MsgBox('This Macro will remove All Constraints from tasks that have predecessors. 'Tamzin Morphy () - Changed = vbNo Then End (causing automation error) to = vbno Then Exit Sub 'You can reverse it by running Restore_NonLogic_Contraints 'This sets the tasks to have a constraint type of 0 which is 'As Soon As Possible' 'Macros to Remove contraints from tasks that are kept in place by logic However, there are exceptions to this, so before you run this macro make sure you understand what constraints are for and the common mistakes in using constraints. Tasks that have predecessors are not likely to also be fixed to a certain date.

Often constraints are accidently created by copying and pasting tasks or setting start or finish dates without fully understanding the consequences.

For example 'start no earlier than' x date or 'must start on' x date. A constraint fixes a start to a particular date. This macro removes all constraints from tasks with predecessors. Add text to the finish of multiple Task Names.Add text to the start of multiple Task Names.If you know where the original macros are please contact me so I can link to the page and give Jack the proper credit.

This page seems to have been moved or deleted so I am publishing here for moment. Most of these macros are examples that were first published on Jack Dahlgren's website Masamiki.

Hide timeline ms project