I changed the Name property of a worksheet in the Properties pane of the VBA Editor. This does not change the text that shows up on the sheets "Tab."

I want to refer to the sheets Name property in my code (not what is on the Tab) incase the your changes the name on the Tab

How do I do this? (I know I've seen this posted here before, but I can't find it.

Sandy,

Something like

Sheet1.Range("A1")

as against

Worksheets("Sheet1").Range("A1")

for the tab name

--

HTH

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

"Sandy" wrote in message
...
I changed the Name property of a worksheet in the Properties pane of the
VBA Editor. This does not change the text that shows up on the sheets "Tab."

I want to refer to the sheets Name property in my code (not what is on the
Tab) incase the your changes the name on the Tab.

How do I do this? (I know I've seen this posted here before, but I can't
find it.

Hey Sandy,

if your sheetname is "InnerSheetName" but on the tab it
says "Sheet1"

you can use [InnerSheetName] to refer to the object.

try this:
msgbox [InnerSheetName].name

this will give a message box with the tab name.

this should work for you.

Regards
Sanjay VA

-----Original Message-----
I changed the Name property of a worksheet in the
Properties pane of the VBA Editor. This does not change
the text that shows up on the sheets "Tab."

I want to refer to the sheets Name property in my code
(not what is on the Tab) incase the your changes the name
on the Tab.

How do I do this? (I know I've seen this posted here
before, but I can't find it.
.

so will this

msgbox InnerSheetName.name


without the brackets.

--
Regards,
Tom Ogilvy

"sanjay va" wrote in message
...
Hey Sandy,

if your sheetname is "InnerSheetName" but on the tab it
says "Sheet1"

you can use [InnerSheetName] to refer to the object.

try this:
msgbox [InnerSheetName].name

this will give a message box with the tab name.

this should work for you.

Regards
Sanjay VA

-----Original Message-----
I changed the Name property of a worksheet in the
Properties pane of the VBA Editor. This does not change
the text that shows up on the sheets "Tab."

I want to refer to the sheets Name property in my code
(not what is on the Tab) incase the your changes the name
on the Tab.

How do I do this? (I know I've seen this posted here
before, but I can't find it.
.