AND ... how do I reference the sheet code names in formulas.
"Tom Ogilvy" wrote:

go into the VBE and look at the project window. You will see each sheet has
two names. One is the tab name, the other is the "codename"

sheet1.Range("A1").Value = 1

uses the code name. Although this can be changed, it is significanly less
likely that a user would do this.

--
Regards,
Tom Ogilvy



"Barb Reinhardt" wrote:

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