Greetings, All!

I'm developing a bi-lingual workbook. In each work sheet I have an option
button that enables me to switch between English and French text and between
American and European date formats. I would also like to change the
worksheet tab from English to its French equivalent but I don't know how.
Can anyone help me with some code? I am currently using the option button
cell link to switch languages.

TIA

Steve H