No I mean

MsgBox Workbooks("Book1.xls").RealSheetName.Name

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rob" wrote in message
...
Thanks Bob. That was my first thought too, but I've tried:
Sub Test
MsgBox Book1.RealSheetName.Name
End Sub
and still have the problem. (If that's what you meant..?)



----- Bob Phillips wrote: -----

This property is called the CodeName. To access from anothjre
workbook, you
have to add the (owning) workbook name as well.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rob" wrote in message
...
A sheet has 2 Name properties, "Name", which appears on the sheet
tab, and
"(Name)".
I want the user to be able to change the "Name" of a worksheet and
my code
still work. This is no problem if I refer to the sheet using the
"(Name)"
property, but if I try to refer to the sheet in this way from another
workbook then it doesn't work. Can anyone tell me why?
Book1 contains the sheet: RealSheetName(User's Sheet Name)
and module1
Book2 contains module2
'My code works in Module1 but not Module2
Sub Test
MsgBox RealSheetName.Name
End Sub