I'd get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager:
You can find it at:
NameManager.Zip from
http://www.oaltd.co.uk/mvp
It'll make working with names much easier. And one of its many features allows
you to localize or globalize names.
=========
If you used a sheet level (or local) name that is identical on two different
sheets, then you won't be able to use the same name (as a global name) on
different sheets.
One other thing, you can refer to these sheet level names by including the sheet
name in your formula:
If you have a local name on Sheet1 that is Sheet1!Test, then you can use this
formula anywhere on sheet1:
=test
And you'll get the value from the cell in Sheet1 named Test.
But if you want to use that name on a different sheet (say sheet2), you have to
change your formula:
=sheet1!test
And you'll get the value from the cell in sheet1 named test.