Peter,
As you have posted in the programming group, I assume you want stable names
for your VBA code?
If so, you could use the codename property as users cannot change this in
Excel. The codename is the name NOT in brackets in the sheet names in the
VBE explorer. Usually both names are the same, but they don't have to be. To
change the codename, click the worksheet in the VBE, and change the name
property in the properties window.
To access a worksheet through its codename, use code like
Sheet1.Range("A1")
instead of
Worksheets("Sheet1").Range("A1")
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
