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:
|
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