Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggling worksheet tab names
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggling worksheet tab names
The only way I know is to toggle the worksheet name. I
would use Option Buttons from the Control Toolbox toolbar instead. Insert the following code into the worksheet code module: Private Sub OptionButton1_Change() If OptionButton1 = True Then ActiveSheet.Name = "Dog" Else ActiveSheet.Name = "Chien" End Sub The above will screw-up any code that references the worksheet name of course. Hope it helps. Regards, Greg -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggling worksheet tab names
Merci!
"Greg Wilson" wrote in message ... The only way I know is to toggle the worksheet name. I would use Option Buttons from the Control Toolbox toolbar instead. Insert the following code into the worksheet code module: Private Sub OptionButton1_Change() If OptionButton1 = True Then ActiveSheet.Name = "Dog" Else ActiveSheet.Name = "Chien" End Sub The above will screw-up any code that references the worksheet name of course. Hope it helps. Regards, Greg -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
toggling | Excel Worksheet Functions | |||
Worksheet Scrolls Two Columns to the Right When Toggling Between T | Excel Discussion (Misc queries) | |||
toggling which worksheet a named range refers to | Excel Discussion (Misc queries) |