Syntax

expression.MacroType

expression A variable that represents a Name object.

Remarks

XlXLMMacroType can be one of these XlXLMMacroType constants.
xlCommand. The name refers to a user-defined macro.
xlFunction. The name refers to a user-defined function.
xlNotXLM. The name doesn't refer to a function or macro.

Example

This example assumes that you created a custom function or command on a Microsoft Excel version 4.0 macro sheet. The example displays the function category, in the language of the macro. It assumes that the name of the custom function or command is the only name in the workbook.

Visual Basic for Applications 
With ActiveWorkbook.Names(1) If .MacroType <> xlNotXLM Then MsgBox "The category for this name is " & .Category Else MsgBox "This name does not refer to" & _ " a custom function or command." End If End With
macro macro type macrotype macrotype property

See also: