In project explorer which name is the codename?

[cellist]

A reputable source states "...The first name for each worksheet outside the parentheses is sheet code name . In nearly all circumstances in VBA, you can use the code name anywhere you would normally use Worksheet("SheetName").

The following code shows

MsgBox "MAIN.Name OK"
MsgBox "sheet1.name error"

Sub check_name()
  Debug.Print Worksheets("MAIN").Name
  MsgBox "MAIN.Name OK"
  On Error GoTo NAME_ERROR:
  Debug.Print Worksheets("sheet1").Name
  On Error GoTo 0
NAME_ERROR:
 MsgBox "sheet1.name error"
End Sub

Have I got it wrong? Or does the reputable source have it wrong?

 

[Norie]

If this is what you see in the Project Explorer,

��Microsoft Excel Objects
|---- Sheet1 (MAIN)

then this will give you a 'subscript out of range' error,

MsgBox Sheets("Sheet1").Name

because Sheets expects the tab name and Sheet1 is the codename.

These will all work.

MsgBox Sheets("MAIN").Name             ' will show 'MAIN'

MsgBox Sheets("MAIN").CodeName    ' will show 'Sheet1'

MsgBox Sheet1.Name                             ' will show 'MAIN'