In your project explorer you see the names of sheets listed like:
Sheet1 (Sheet1)
Sheet2 (Sheet2)
etc.

If you change the tab names it becomes:
Sheet1 (My Sheet)
Sheet2 (His Sheet)
etc.

In the second example, to refer to Sheets("My Sheet") by code name you
simply use:
Sheet1

For example:
Sheet1.Select

The code names can be chanced from the Properties window. Open the
properties window and click on the sheet you want to rename in the
project explorer. You'll then see the code name at the top of the
properties window where it can be edited. - pikus


---
Message posted from http://www.ExcelForum.com/