Name.MacroType (Excel)

Returns or sets what the name refers to.

xlCommand - Custom command, xlFunction - Custom function, xlNotXLM - Not a macro.
ActiveWorkbook.Names(1).MacroType = xlCommand
Name.MacroType procedure builder