Thanks everyone for your assistance. That really helps clean up my code.

"NickHK" wrote:

Barb,
You are looking fir the .Codename of the WS. The user cannot change it.
It works like an object, rather than a name:
WS_WithCodeName.Range("A1").Value=NewValue


NickHK

"Barb Reinhardt" ...
We are creating a workbook that will need to activate several different
sheets and perform some calculations. Is there a way to address the
following:

Sheet name changed by user - macro looking for sheet name on tab
Sheet reordered in workbook

It seems as though I saw a way to define a "hidden" name for the worksheet
that the users couldn't see, but I can't seem to find it. Does this
exist?
If so, how would I use it?

Thanks,
Barb Reinhardt