NameLocal Property [Excel 2003 VBA Language Reference]
Returns or sets the name of the object, in the language of the user. Read/write String for Name, read-only String for Style.
If the style is a built-in style, this property returns the name of the style in the language of the current locale.
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