Equivalent to clicking the Options command on the Tools menu and then clicking the General tab from the Options dialog box. Sets various general Microsoft Excel settings.
Syntax
OPTIONS.GENERAL(R1C1_mode, dde_on, sum_info, tips, recent_files, old_menus, user_info, font_name, font_size, default_location, alternate_location, sheet_num, enable_under)
OPTIONS.GENERAL?(R1C1_mode, dde_on, sum_info, tips, recent_files, old_menus, user_info, font_name, font_size, default_location, alternate_location, sheet_num, enable_under)
Arguments correspond to option buttons, check boxes and text boxes on the General tab of the Options dialog box. Arguments corresponding to check boxes are logical values. If an argument is TRUE, the check box is selected; if FALSE, the check box is cleared; if omitted, the current setting is not changed.
R1C1_mode is a number specifying the reference style. Use 1 for A1 style references; 2 for R1C1 style references.
Dde_on is a logical value corresponding to the Ignore Other Applications check box, which if TRUE ignores DDE request from other applications. If FALSE, DDE requests from other applications are allowed to happen.
Sum_info is a logical value corresponding to the Prompt For Workbook Properties check box, which if TRUE displays the Summary tab of the Properties dialog box when a workbook is initially saved. If FALSE, the dialog box is not displayed.
Tips is a logical value corresponding to the Reset TipWizard check box in Microsoft Excel 95 or earlier versions, which, if TRUE, resets the TipWizard. In Microsoft Excel 97 or later, tips corresponds to the Reset My Tips button in the Office Assistant dialog box. If FALSE, the TipWizard will not be reset.
Recent_files is a logical value corresponding to the Recently Used File List check box, which if TRUE displays the four last opened files from the File menu. If FALSE, the file list will not be displayed.
Old_menus is a logical value corresponding to the Microsoft Excel 4.0 Menus check box in Microsoft Excel version 5.0, which if TRUE replaces the current menu bar with the Microsoft Excel 4.0 menu bar. If FALSE, the menu bar will not be replaced. This argument is for compatibility with Microsoft Excel version 5.0 only and is ignored in later versions. User_info corresponds to the Name text box, and is the name of the user of this copy of Microsoft Excel. By default it is the registered user, but can be changed to work on a network.
Font_name corresponds to the Standard Font text box, and is the name of the default font.
Font_size corresponds to the Size drop-down edit box, and is the size of the default font.
Default_location corresponds to the Default File Location text box, and is the default location that the File Open command displays. The Default is where Microsoft Excel is installed.
Alternate_location corresponds to the Alternate Startup File Location text box, and is the alternate startup directory.
Sheet_num corresponds to the Sheets In New Workbook spin control, and is the number of sheets in a new workbook. Default is 3. Can go up to 255.
Enable_under enables underlining of the menus. Used for only Microsoft Excel for the Macintosh. Ignored in Microsoft Excel for Windows.
Related Functions
OPTIONS.LISTS.DELETE Deletes a custom list
OPTIONS.LISTS.GET Returns contents of custom AutoFill lists
OPTIONS.VIEW Sets various view settings
Return to index