Bewerken

Delen via


_Application.MacroOptions Method

Definition

Corresponds to options in the Macro Options dialog box. You can also use this method to display a user defined function (UDF) in a built-in or new category within the Insert Function dialog box.

public void MacroOptions (object Macro, object Description, object HasMenu, object MenuText, object HasShortcutKey, object ShortcutKey, object Category, object StatusBar, object HelpContextID, object HelpFile);
Public Sub MacroOptions (Optional Macro As Object, Optional Description As Object, Optional HasMenu As Object, Optional MenuText As Object, Optional HasShortcutKey As Object, Optional ShortcutKey As Object, Optional Category As Object, Optional StatusBar As Object, Optional HelpContextID As Object, Optional HelpFile As Object)

Parameters

Macro
Object

Optional Object. The macro name or the name of a user defined function (UDF).

Description
Object

Optional Object. The macro description.

HasMenu
Object

Optional Object. This argument is ignored.

MenuText
Object

Optional Object. This argument is ignored.

HasShortcutKey
Object

Optional Object. True to assign a shortcut key to the macro (ShortcutKey must also be specified). If this argument is False, no shortcut key is assigned to the macro. If the macro already has a shortcut key, setting this argument to False removes the shortcut key. The default value is False.

ShortcutKey
Object

Optional Object. Required if HasShortcutKey is True; ignored otherwise. The shortcut key.

Category
Object

Optional Object. An integer that specifies an existing macro function category (Financial, Date & Time, or User Defined, for example). See the remarks section to determine the integers that are mapped to the built-in categories. You can also specify a string for a custom category. If you provide a string, it will be treated as the category name that is displayed in the Insert Function dialog box. If the category name has never been used, a new category is defined with that name. If you use a category name that is that same as a built-in name, Excel will map the user defined function to that built-in category.

StatusBar
Object

Optional Object. The status bar text for the macro.

HelpContextID
Object

Optional Object. An integer that specifies the context ID for the Help topic assigned to the macro.

HelpFile
Object

Optional Object. The name of the Help file that contains the Help topic defined by HelpContextId.

Remarks

The following table lists which integers are mapped to the built-in categories that can be used in the Category parameter.

1 Financial
2 Date & Time
3 Math & Trig
4 Statistical
5 Lookup & Reference
6 Database
7 Text
8 Logical
9 Information
10 Commands
11 Customizing
12 Macro Control
13 DDE/External
14 User Defined
15First custom category
16Second custom category
17Third custom category
18Fourth custom category
19Fifth custom category
20Sixth custom category
21Seventh custom category
22Eighth custom category
23Ninth custom category
24Tenth custom category
25Eleventh custom category
26Twelfth custom category
27Thirteenth custom category
28Fourteenth custom category
29Fifteenth custom category
30Sixteenth custom category
31Seventeenth custom category
32Eighteenth custom category

Applies to