_Application.MacroOptions Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 |
| 15 | First custom category |
| 16 | Second custom category |
| 17 | Third custom category |
| 18 | Fourth custom category |
| 19 | Fifth custom category |
| 20 | Sixth custom category |
| 21 | Seventh custom category |
| 22 | Eighth custom category |
| 23 | Ninth custom category |
| 24 | Tenth custom category |
| 25 | Eleventh custom category |
| 26 | Twelfth custom category |
| 27 | Thirteenth custom category |
| 28 | Fourteenth custom category |
| 29 | Fifteenth custom category |
| 30 | Sixteenth custom category |
| 31 | Seventeenth custom category |
| 32 | Eighteenth custom category |