I know :-)

And that was the purpose of my code - to rename the codename to the proper
locale - thus actually not needing the number of the sheet...

CE



"Rick Rothstein" wrote in message
...
since the only real issue between 'Name' and 'CodeName'
is the number - which was a minor issue for me

Which number are you talking about? I ask because you may not realize that
both the sheet's name AND its code name can be changed. Go into the VB
editor (press ALT+F11) and click on one of the sheets listed in the
Project Window (press CTRL+R if it is not visible), then look at the
Properties Window (press F4 if it is not visible)... the first item in the
Properties list is (Name)... the word Name with parentheses around it...
that is the Code Name... further down the list is the work Name (with no
parentheses around it)... that is the Sheet Name... both of these can be
changed by the user if so desired.

Rick Rothstein (MVP - Excel)