Hi,

I would like to have a code to change the sheet index property through VBA, I tried the below but it didn't work:

Sheets("Sales").CodeName = "Sheet2"
Sheets("Sales").Index = "Sheet2"

Please help, appreciate.