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