PublishObject.HtmlType procedure builder

PublishObject.HtmlType (Excel)

Returns or sets the type of HTML generated by Microsoft Excel when you save the specified item to a webpage. Can be one of the XlHtmlType constants specifying whether the item is static or interactive on the webpage. The default value is xlHtmlStatic.

xlHtmlStatic - Use static (noninteractive) HTML for viewing only.
ActiveWorkbook.PublishObjects(1).HtmlType = xlHtmlStatic