Each sheet in a workbook has the name property that you see on the tab and a
codename property that you can use in VBA macros. The codename is much more
difficult for the average user to change, but not impossible to be changed.

If you're in the VBE looking at the project explorer, you'll see the codename
followed by the name (in parens).

Like:
Sheet1 (NameYouSeeInExcel)

You maybe able to make sure your code refers to this codename property instead
of the name property.

Instead of:
With thisworkbook.worksheets("NameYouSeeInExcel")
use
With Sheet1

You can change the .codename property (Show the project explorer, select the
sheet object, hit F4 to show the properties, and then type over the (Name) (with
the ()'s) property.

==========
So....

If the codenames are that tablle#stuff, maybe just renaming the codename will
work for you.

If those tablle# are variables that the developer created, you'll have to change
the code (Edit|replace in all the current project (and step through the
changes--that string could be used for lots of things???).


wayne wrote:

I have a spreadsheet with VBA code that does not work reliably. Upon
close examination, I find the worksheets are identified as tablle1,
tablle2, etc while the VBA is written in English. Is there a way to
rename the worksheets at the program level? Note: I am referring to the
name you see in the vba editor in front of the name you type into the
worksheet when changing the name.

TIA
--
Wayne
glenmeadows.us
A democracy is nothing more than mob rule, where fifty-one percent of
the people may take away the rights of the other forty-nine. [Thomas
Jefferson]

--

Dave Peterson