Name.MacroType (Excel)

Returns or sets what the name refers to. Possible return values are xlCommand - Custom command, xlFunction - Custom function, xlNotXLM - Not a macro.

ActiveWorkbook.Names(1).MacroType = xlCommand