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.
expression A variable that represents a PublishObject object.
The title is usually displayed in the window title bar when the document is viewed in the Web browser.
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"