Thanks Paul.
After more research, I think that I cannot refer to sheet code names outside
of the active workbook.
Thanks again for the prompt reply.


"Paul C" wrote in message
...
if the name of the sheet has been changed in VBA then just the name will
work

Sheet2.activate

Keep in mind that the code name for the sheet and the name that appears on
the sheet tab may not be the same.
--
If this helps, please remember to click yes.


"Bassman62" wrote:

I have some old code that refers to sheet names and I'd like to change
these
to the sheet code names.
However, apparently code names are objects of a different type than sheet
Names.
Here's an example of what I'm trying to do:
Change
ThisWorkbook.Sheets("Report").Activate
To
ThisWorkbook.Sheet2.Activate 'Error: Method or Data Member not
found.
This seems elementary but I can't seem to get the syntax correct.
How can I refence a code name of a particula workbook?
Thanks.