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...