Hi again,
That is referred to as the sheet's CodeName property. From vb help:
CodeName Property
Returns the code name for the object. Read-only String.
Note The value that you see in the cell to the right of (Name) in the Properties window is the code name of the selected object. At design time, you can change the code name of an object by changing this value. You cannot programmatically change this property at run time.
This is incorrect though, as you can actually get to the property. Not sure how you would use this to advantage, but try:
Option Explicit
Sub exa3()
Dim wks As Worksheet
With ThisWorkbook
Set wks = .Worksheets.Add(After:=.Worksheets(.Worksheets.Count), _
Type:=xlWorksheet)
wks.Name = "Variations_" & Format(.Worksheets.Count, "00")
wks.Parent.VBProject.vbcomponents(wks.CodeName) _
.Properties("_CodeName") = "sht" & wks.Name
End With
End Sub
Hope that helps,
Mark