The following example uses the Mode property to return the mode of the active project. The value returned is a predefined constant representing the project's mode.
Debug.Print Application.VBE.ActiveVBProject.Mode