NameLocal Property
Returns or sets the name of the object, in the language of the user. Read/write String for Name, read-only String for Style.
Remarks
If the style is a built-in style, this property returns the name of the style in the language of the current locale.
Example
This example displays the name and localized name of style one in the active workbook.
With ActiveWorkbook.Styles(1)
MsgBox "The name of the style is " & .Name
MsgBox "The localized name of the style is " & .NameLocal
End With