Macro Sheets Only
Equivalent to choosing the Add button from the View Manager dialog box, which appears when you choose the View Manager command from the View menu. Creates or replaces a view.
If this function is not available, you must install the View Manager add-in macro.
Syntax
VIEW.DEFINE(view_name, print_settings_log, row_col_log)
View_name is text enclosed in quotation marks and specifies the name of the view you want to define for the sheet. If the workbook already contains a view with view_name, the new view replaces the existing one.
Print_settings_log is a logical value that, if TRUE or omitted, includes current print settings in the view or, if FALSE, does not include current print settings in the view.
Row_col_log is a logical value that, if TRUE or omitted, includes current row and column settings in the view or, if FALSE, does not include current row and column settings in the view.
Related Functions
VIEW.DELETE Removes a view from the active workbook
VIEW.SHOW Shows a view
List of Command-Equivalent Functions