I want to change hundreds of tasks in a project from "fixed work" to "fix duration" type.

  • When I select multiple tasks - the "Information" dialog changes only one if them.

  • I have also tried to add a "type" column to the list of tasks and copy-paste the necessary type there. But, for some reason, it works not for all the tasks, most of them, although changeable one-by-one, remain unchanged if I try to past a value, copied from another row.

Could anybody show a solution? Preferably with a screenshot from Project.

2 Answers 2


I showed the "Type" column, changed the first entry to "Fixed Duration", then dragged that value down through the rest of the rows, and it worked.

Step 1:

enter image description here

Step 2:

enter image description here

Step 3: click in the "Fixed Duration" field in Row 1, point to the bottom right corner and drag the field to the other rows.

enter image description here

Then you can hide the "Type" column again.


I effectively solved the issue by a very simple macros: just add this text into macros Sub, save macros and then run it over selected tasks. If necessary - change task type in the macros.

Dim ProjTasks As Tasks
Dim ProjTask As Task

If ActiveSelection = 0 Then
    MsgBox "Choose tasks to change type"
    Exit Sub
End If

For Each ProjTask In ActiveSelection.Tasks
    If ProjTask.Summary = False Then
        ProjTask.Type = pjFixedDuration

    End If
Next ProjTask

But I still wonder whether there is a standard solution

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.