Application.OptionsEditEx method (Project)

Sets options for Project, where colors can be hexadecimal values, or opens the Project Options dialog box.

Syntax

expression. OptionsEditEx( _MoveAfterReturn_, _DragAndDrop_, _UpdateLinks_, _CopyResourceUsageHeader_, _PhoneticInfo_, _PhoneticType_, _MinuteLabelDisplay_, _HourLabelDisplay_, _DayLabelDisplay_, _WeekLabelDisplay_, _YearLabelDisplay_, _SpaceBeforeTimeLabel_, _SetDefaults_, _MonthLabelDisplay_, _SetDefaultsTimeUnits_, _HyperlinkColor_, _FollowedHyperlinkColor_, _UnderlineHyperlinks_, _SetDefaultsHyperlink_, _InCellEditing_ )

expression An expression that returns an Application object.

Parameters

Name Required/Optional Data type Description
MoveAfterReturn Optional Boolean True if the next cell or field becomes active when ENTER is pressed. False if the current cell or field remains active. The Move selection after enter option is on the Advanced tab of the Project Options dialog box.
DragAndDrop Optional Boolean True if cells may be copied or moved by dragging them; otherwise, False. The Allow cell drag and drop option is on the Advanced tab.
UpdateLinks Optional Boolean True if Project asks to update automatic links when the relevant information changes; otherwise, False. The Ask to update automatic links option is on the Advanced tab.
CopyResourceUsageHeader Optional Due to changes in the Project object model, this argument is ignored. It is retained so that existing macros that use this argument do not cause errors.
PhoneticInfo Optional Boolean True if phonetic information is automatically provided for resource names and custom fields; otherwise, False. The PhoneticInfo argument is ignored unless the Japanese version of Project is used.
PhoneticType Optional Integer Specifies the type of characters used to display phonetic information. Can be one of the following PjPhoneticType constants: pjKatakanaHalf, pjKatakana, or pjHiragana. The PhoneticType argument is ignored unless the Japanese version of Project is used.
MinuteLabelDisplay Optional Integer Specifies how the minute label displays. The minute label display corresponds to the Minutes list, which is on the Advanced tab. For example, setting the MinuteLabelDisplay argument to 0 sets the Minutes list to the first value in the list (m). Valid values are 0–2.
HourLabelDisplay Optional Integer Specifies how the hour label displays. The hour label display corresponds to the Hours list, which is found on the Advanced tab. For example, setting the HourLabelDisplay argument to 2 sets the Hours list to the third value in the list (hour). Valid values are 0–2.
DayLabelDisplay Optional Integer Specifies how the day label displays. The day label display corresponds to the Days list, which is found on the Advanced tab. For example, setting the DayLabelDisplay argument to 1 sets the Days list to the second value in the list (dy). Valid values are 0–2.
WeekLabelDisplay Optional Integer Specifies how the week label displays. The week label display corresponds to the Weeks list, which is found on the Advanced tab. For example, setting the WeekLabelDisplay argument to 0 sets the Weeks list to the first value in the list (w). Valid values are 0–2.
YearLabelDisplay Optional Integer Specifies how the year label displays. The year label display corresponds to the Years list, which is found on the Advanced tab. For example, setting the YearLabelDisplay argument to 1 sets the Years list to the second value in the list (yr). Valid values are 0–2.
SpaceBeforeTimeLabel Optional Boolean True if a time value should be separated from the time label by a space; otherwise, False. Corresponds to the Add space before label option on the Advanced tab.
SetDefaults Optional Boolean True if values of the arguments in the OptionsEdit method are set to the default values for new projects. The default value is False, which means that options are set only for the active project.
MonthLabelDisplay Optional Integer Specifies how the month label displays. The month label display corresponds to the Months list, which is found on the Advanced tab. For example, setting the MonthLabelDisplay property to 2 sets the Months list to the third value in the list (month). Valid values are 0–2.
SetDefaultsTimeUnits Optional Boolean True if the values of time units specified in the Display options for this project section (Advanced tab) are used as the default values for new projects. The default value is False, which means that the display options of time units are set only for the active project.
HyperlinkColor Optional Integer The color used to denote unfollowed hyperlinks. Can be a hexadecimal RBG value, where red is the last byte. For example, &HFF0000 is blue.
FollowedHyperlinkColor Optional Long The color used to denote followed hyperlinks. Can be a hexadecimal RBG value, where red is the last byte. For example, &HFF00FF is purple.
UnderlineHyperlinks Optional Boolean True if hyperlinks are underlined; otherwise, False.
SetDefaultsHyperlink Optional Boolean True if the hyperlink options specified in the Display options for this projectsection (Advanced tab) are used as the default values for new projects. The default value is False, which means that the hyperlink options are set only for the active project.
InCellEditing Optional Boolean True if in-cell editing is enabled; otherwise, False. Corresponds to the Edit directly in cell option in the Edit section of the Advanced tab.

Return value

Boolean

Remarks

If an argument is omitted, its default value is specified by the current setting in the Project Options dialog box.

Using the OptionsEditEx method with no arguments displays the Project Options dialog box with the General tab selected.

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.