Equivalent to selecting a view and clicking the Show button in the Custom Views dialog box, which appears when you click the Custom Views command on the View menu. In Microsoft Excel 97 or later, the Custom Views command replaces the View Manager command that was available in Microsoft Excel 95 and earlier versions. Shows a view.
If this function is not available in Microsoft Excel 95 or in earlier versions, you must install the View Manager add-in.
Syntax
VIEW.SHOW(view_name)
VIEW.SHOW?(view_name)
View_name is text enclosed in quotation marks and specifies the name of a view in the active workbook.
Remarks
VIEW.SHOW returns the #VALUE error value if view_name is invalid or the workbook is protected.
Related Functions
VIEW.DEFINE Creates or replaces a view
VIEW.DELETE Removes a view from the active workbook
Return to index