Project.Type property (Project)
Gets the type of a project. Read-only PjProjectType.
Syntax
expression.Type
expression A variable that represents a Project object.
Remarks
The Type property can be one of the PjProjectType constants.
Example
The following example determines whether an open project is an enterprise project and is checked out. If the project is not checked out, the example tries to check out the project. If the project is checked out by another user, Project shows a dialog box with the message, "To check out, DOMAIN\UserName must close the project in their session or contact your administrator to check in the project."
Sub CheckOutOpenEnterpriseProjects()
Dim openProjects As Projects
Dim proj As Project
Set openProjects = Application.Projects
On Error Resume Next
For Each proj In openProjects
If Application.IsCheckedOut(proj.Name) Then
If proj.Type = pjProjectTypeEnterpriseCheckedOut Then
Debug.Print "'" & proj.Name & "'" & " is already checked out."
ElseIf proj.Type = pjProjectTypeNonEnterprise Then
Debug.Print "'" & proj.Name & "'" & " is not an enterprise project."
End If
Else
proj.CheckoutProject
Debug.Print "Attempted to check out: '" & proj.Name & "'"
End If
Next proj
End Sub
See also
Project Object PjProjectType Enumeration
CheckoutProject Method Application.IsCheckedOut Property
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.