MacroType Property

Applies To

Name object.

Description

Returns or sets what the name refers to. Read/write Long.

Can be one of the following XlMacroType constants.

Constant	Meaning

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.

See Also

Category property.

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.

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