Workbook.ServerViewableItems property (Excel)
Allows a developer to interact with the list of published objects in the workbook that are shown on the server. Read-only.
expression A variable that represents a Workbook object.
This property returns a collection of the items that could be published to Excel Services. It can include Tables, PivotTables, Named Ranges, and Charts. It can also contain Sheets as long as it is not a mixture of Sheets and the before mentioned list.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.