Thank you so much for your reply! It worked but I think I didn't explain my question correctly.

I would like the active tab itself to change the color, not the entire worksheet. If that makes sense. In excel, all tabs are white by default and I want the tab I am currently in to change color from white to red. And if I move to another tab, then new tab becomes red and the old one is white again.

Thank you in advance!