1 . I want to change sheet name automatically by running macro (VB code)

if sheet name = x

then sheet name will be changed to y after openning the file automatically.

can u pls give me the code?

--------------------------------------------------------
2.
if i want to trigger a macro on any change in sheet 1, what is the code?