OPTIONS.GENERAL

Macro Sheets Only

Equivalent to choosing the Options command from the Tools menu and then selecting 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 in the General 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 sytle. 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 Summary Info check box, which if TRUE displays the summary information 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, which if TRUE resets the TipWizard. 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, 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.

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 16. 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

List of Command-Equivalent Functions