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?

 

[mrshl9898]

Not certain what you are trying to achieve.

Hope this clears things up.

Sub check_name()  
  Debug.Print Worksheets("MAIN").Name
  MsgBox Worksheets("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

 

[Leith Ross]

Hello cellist,

The worksheet has 2 names: The friendly name that you see on the tab and the code name which assigned by the application when the sheet is created. The friendly name can be changed. The code name is read only and can not be changed.

You can access either name by using the correct property.

Sub Test()
    MsgBox "The ActiveSheet Name is '" & ActiveSheet.Name & "'" &  vbLf "The Code name is '" & "'" & ActiveSheet.Codename
End Sub

 

[Norie]

In the Project Explorer the tab name is the one in brackets, the other name is the codename.

For example here, the codename is Sheet1 and the tab name is MAIN.

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

 

[Marcelo Branco]

The friendly name can be changed. The code name is read only and can not be changed.

Hi Leith

You are right, the code name cannot be changed programmatically, but it can be changed at design time.
See Remarks in
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/worksheet-codename-property-excel

M.

 

[cellist]

I'm just trying to understand how the two names show up in Project Explorer, as what my "reputable source" says doesn't seem to match what I'm seeing on my system.

Is the code you are showing your code? Is that what you "hope clears things up"? But isn't it the same as the code I posted?

Thanks.

 

[Norie]

In Project Explorer the tab/sheet name is in brackets, the codename isn't.


?Microsoft Excel Objects
|---- codename (sheetname)

 

[mrshl9898]

"Sheet1.Name" is the same as "Worksheets("MAIN").Name" in your example.

My previous was (incorrectly) trying to demonstrate this, and also show that:

MsgBox Sheet1.Name & " error"

is not the same as

MsgBox "sheet1.name error"

The first returns "MAIN error" and the latter "sheet1.name error"

 

[cellist]

Yes, I see that your code demonstrates which name is the code name.
But when I run Debug.Print Worksheets("sheet1").name to check that I can use either the tab name or the code name, I get an error that implies that "sheet1" isn't defined--9Subscript out of range. The same command with "MAIN" gets a different message--438Object doesn't support this property or method
Does that seem odd to you?

Thanks for your reply.
BTW, I'm guessing from your signature that Leith rhymes with faith?

 

[cellist]

Yeh, I know that. Guess I got tired of type & all over the place.

Thanks.