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 module
Book2 contains module

'My code works in Module1 but not Module
Sub Tes
MsgBox RealSheetName.Nam
End Su

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

Thanks Bob. That was my first thought too, but I've tried
Sub Tes
MsgBox Book1.RealSheetName.Nam
End Su
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, yo
have to add the (owning) workbook name as well

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

"Rob" wrote in messag
..
A sheet has 2 Name properties, "Name", which appears on the sheet tab, an
"(Name)"
I want the user to be able to change the "Name" of a worksheet and my cod
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 anothe
workbook then it doesn't work. Can anyone tell me why
Book1 contains the sheet: RealSheetName(User's Sheet Name
and module
Book2 contains module
'My code works in Module1 but not Module
Sub Tes
MsgBox RealSheetName.Nam
End Su

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