Hi Nono,

If only the sheet name (and not the code name) has been changed, then try
the following simple macro:

Sub TesterA()
MsgBox Sheet1.Name
End Sub


---
Regards,
Norman



"nono" wrote in message
...
how can i find sheet1 when it was renamed?