Table of contents
Collapse the table of content
Expand the table of content

Application.FilePageSetupCalendarTextEx Method (Project)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Formats the text of calendar views for printing, where the text color can be a hexadecimal value.


expression. FilePageSetupCalendarTextEx( ** Name, ** Item, ** Font, ** Size, ** Bold, ** Italic, ** Underline, ** Color )

expression An expression that returns an Application object.


NameRequired/OptionalData TypeDescription
NameOptionalStringThe name of the calendar to edit.
ItemOptionalLongThe text item to format. Can be one of the PjPageSetupCalendarItem constants.
FontOptionalStringThe name of the font.
SizeOptionalIntegerThe size of the font in points
BoldOptionalBooleanTrue if the font is bold; otherwise, False.
ItalicOptionalBooleanTrue if the font is italic; otherwise, False.
UnderlineOptionalBooleanTrue if the font is underlined; otherwise, False.
ColorOptionalLongThe color of the text. Can be a hexadecimal RGB value, where red is the last byte. For example, the value &;H01FFFF is yellow.

Return Value



Using the FilePageSetupCalendarTextEx method without any arguments displays the Text Styles dialog box.

NoteFilePageSetupCalendarTextEx works only for printing calendar views.


The following example formats monthly titles in red for printing.

Sub File_PageSetupCalendarText() 

    'Activate the Calandar view. 
    ViewApply Name:="&;Calendar" 

    FilePageSetupCalendarTextEx Item:=pjMonthlyTitles, Color:=&;0101FF 
End Sub
© 2018 Microsoft