Hello,

I have a question about referencing a specific sheet.

I see you can do this:

ThisWorkbook.Worksheets("MySpecialSheet").Select

Or

ThisWorkbook.Worksheets(2).Select

However, if the user changes the name of the sheet to "MySpecialSheet2" or
re-order the tabs you cannot use those.

I see there is a property CodeName. Which always has the default "Sheet<x"
name.

Can this be used?

Is there some other way to identify the sheet?



Thanks

Yes you can use CodeName

Sheet2.Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"greg" wrote in message
...
Hello,

I have a question about referencing a specific sheet.

I see you can do this:

ThisWorkbook.Worksheets("MySpecialSheet").Select

Or

ThisWorkbook.Worksheets(2).Select

However, if the user changes the name of the sheet to "MySpecialSheet2" or
re-order the tabs you cannot use those.

I see there is a property CodeName. Which always has the default
"Sheet<x"
name.

Can this be used?

Is there some other way to identify the sheet?



Thanks

thanks for the help


"Bob Phillips" wrote in message
...
Yes you can use CodeName

Sheet2.Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"greg" wrote in message
...
Hello,

I have a question about referencing a specific sheet.

I see you can do this:

ThisWorkbook.Worksheets("MySpecialSheet").Select

Or

ThisWorkbook.Worksheets(2).Select

However, if the user changes the name of the sheet to "MySpecialSheet2"
or
re-order the tabs you cannot use those.

I see there is a property CodeName. Which always has the default
"Sheet<x"
name.

Can this be used?

Is there some other way to identify the sheet?



Thanks