VIEW.DELETE macro

Equivalent to selecting a view and clicking the Delete 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 replaced the View Manager command that was available in Microsoft Excel 95 and earlier versions. Removes a view from the active workbook.

If this function is not available in Microsoft Excel 95 or in earlier versions, you must install the View Manager add-in.

Syntax

VIEW.DELETE(view_name)

View_name    is text enclosed in quotation marks and specifies the name of the view in the current workbook that you want to delete.

Remarks

VIEW.DELETE returns the #VALUE error value if view_name is invalid or if the workbook is protected.

Related Functions

VIEW.DEFINE   Creates or replaces a view

VIEW.SHOW   Shows a view

Return to index