Name.CategoryLocal Property (Excel)
Returns or sets the category for the specified name, in the language of the user, if the name refers to a custom function or command. Read/write String.
Syntax
expression .CategoryLocal
expression A variable that represents a Name object.
Example
This example displays, in the language of the user, the function category of either a custom function or a command created on a Microsoft Excel 4.0 macro sheet. The example assumes that the custom function name or command name is the only name in the workbook.
With ActiveWorkbook.Names(1)
If .MacroType <> xlNone Then
MsgBox "The category for this name is " & .CategoryLocal
Else
MsgBox "This name does not refer to" & _
" a custom function or command."
End If
End With