Published: July 16, 2012
Returns the PublishObjects
A variable that represents a Workbook object.
This example publishes all static PublishObject objects in the active workbook to the Web page.
Set objPObjs = ActiveWorkbook.PublishObjects
For Each objPO in objPObjs
If objPO.HtmlType = xlHTMLStatic Then