MacroType Property

From Microsoft Excel Visual Basic

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.