Hi

You can refer to it by CodeName - this is another property of a worksheet and isn't so easy to change so it is much more stable. If you look in the Project Window of your VBE (top left usually) at your workbooks, the codenames will be the name given first for each sheet. The name is what is in the brackets.

So, you can refer to the sheet like:

Sheet1.Activate   'amend codename as appropriate