The CODENAME record stores the name for a worksheet object. It is not necessarily the same name as you see in the workbook sheet tab, but the name you see in the VBE project window for the worksheet.
Record Data—BIFF8
Offset
Name
Size
Contents
4
stCodeName
var
The name as a unicode string; for more information, see "Unicode Strings in BIFF8" on page 264.