PublishObject.Title Property (Excel)
Returns or sets the title of the Web page when the document is saved as a Web page. Read/write String.
Syntax
expression .Title
expression A variable that represents a PublishObject object.
Remarks
The title is usually displayed in the window title bar when the document is viewed in the Web browser.
Example
This example sets the Web page title to "Sales Forecast" when the first item in the first workbook is saved as a Web page.
Workbooks(1).PublishObjects(1).Title = "Sales Forecast"