When you define the name--either via the Insert|Name|define dialog or by typing
the name into the namebox (to the left of the formulabar, you can include the
sheetname.

'Sheet 99'!myNameHere
(in the Namebox, with the range selected--and make sure you hit enter)

Or
Names in workbook: 'Sheet 99'!myNameHere
Refers to: ='Sheet 99'!$A$2:$Z$99
(in the dialog)




If you have to localize (or globalize) and existing name, you'll want to use Jan
Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager:
NameManager.Zip from http://www.oaltd.co.uk/mvp

In fact, if you're working with names, you'll want this!

Rich Davies wrote:

I have a workbook with many sheets with identical format and similar data. I
need to have cells and ranges named, but the names need to be local to a
particular worksheet.

I've accomplished that in the past by setting up one worksheet, naming
everything to my liking, then making a copy of the worksheet. In the copy,
all the names are nicely qualified with the name of the sheet.

I've done that, and now I need to expand the worksheets. I can't find a way
to add new names and make them local to any sheet. I don't want to go through
the copy process again due to the the impact on other sheets that collect
data from all these other sheet.

--

Dave Peterson