OPTIONS.GENERAL macro

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