Sub CompletePercentSub ()
Dim t As Task Dim i As Integer
'Iteriert durch die gesamte MS-Projektdatei
i = 1 für jedes t in ActiveProject.Tasks
SelectRow Row:=i, RowRelative:=False If Not t Is Nothing Then Select Case t.Status Case 0 'Complete Font32Ex CellColor:=&H98FB98 'LIGHT GREEN Case 1 'On Schedule Font32Ex CellColor:=&HE0FFFF 'TAN Case 2 'Late Font32Ex CellColor:=&HC0FF& 'LIGHT RED Case 2 'Future Task Font32Ex CellColor:=&HFFFFFF 'WHITE End Select End If
i = i + 1
Nächstes T
End Sub