Skip to content

Latest commit

 

History

History
52 lines (38 loc) · 3.04 KB

Project.Application.GridlinesEditEx.md

File metadata and controls

52 lines (38 loc) · 3.04 KB
title keywords f1_keywords ms.service api_name ms.assetid ms.date ms.localizationpriority
Application.GridlinesEditEx method (Project)
vbapj.chm2152
vbapj.chm2152
project-server
Project.Application.GridlinesEditEx
fad3c4cc-2643-4af1-ca6b-f376b24a97bb
02/16/2019
medium

Application.GridlinesEditEx method (Project)

Edits gridlines, where colors can be hexadecimal values.

Syntax

expression.GridlinesEditEx (Item, NormalType, NormalColor, Interval, IntervalType, IntervalColor)

expression An expression that returns an Application object.

Parameters

Name Required/Optional Data type Description
Item Required Integer The gridline to edit. Can be one of the following PjGridline constants:
  • If the Gantt Chart is active: pjBarRows, pjGanttCurrentDate, pjGanttPageBreaks, pjGanttProjectFinish, pjGanttProjectStart, pjGanttRows, pjGanttSheetColumns, pjGanttSheetRows, pjGanttStatusDate, pjGanttTitleHorizontal, pjGanttTitleVertical, pjMajorColumns, or pjMinorColumns.
  • If the Calendar view is active: pjCalendarDays, pjCalendarWeeks, pjTitleHorizontal, pjTitleVertical, pjDateBoxTop, or pjDateBoxBottom.
  • If the Resource Graph is active: pjMajorVertical, pjMinorVertical, pjHorizontal, pjGraphCurrentDate, pjGraphTitleHorizontal, pjGraphTitleVertical, pjGraphProjectStart, pjGraphProjectFinish, or pjGraphStatusDate.
  • If the Task Sheet or Resource Sheet is active: pjSheetColumns, pjSheetRows, pjSheetTitleHorizontal, pjSheetTitleVertical, or pjSheetPageBreaks.
  • If the Task Usage or Resource Usage view is active: pjUsageColumns, pjUsageRows, pjUsageSheetRows, pjUsageSheetColumns, pjUsageTitleHorizontal, pjUsageTitleVertical, or pjUsagePageBreaks.
NormalType Optional Integer The type for normal gridlines. Can be one of the following PjLineType constants: pjNoLines, pjContinuous, pjCloseDot, pjDot, or pjDash.
NormalColor Optional Long The color of normal gridlines. Can be a hexadecimal RGB value, where red is the last byte. For example, &H0088FF is orange.
Interval Optional Integer A number from 0 to 99 that specifies the interval between gridlines.
IntervalType Optional Integer The type for secondary gridlines. Can be one of the PjLineType constants.
IntervalColor Optional Long The color of secondary gridlines. Can be a hexadecimal RGB value, where red is the last byte.

Return value

Boolean

Example

The following example changes the major gridlines to red.

Sub Gridlines_Edit() 
    'Activate Gantt Chart view 
    ViewApply Name:="&Gantt Chart" 
    GridlinesEditEx Item:=pjMajorColumns, NormalColor:=&HFF 
End Sub

[!includeSupport and feedback]