VIEW.SHOW macro

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