Abby
When entering the names make them local to the sheet.
Select a range to name.
InsertNameDefine
In the "Names in Workbook" enter a name as such.............
Sheetname!MyRange
MyRange will only show in the Go To when Sheet1 is active.
Or download and use Jan Karel Pieterse's Name Manager Add-in which allows you to
change the names to local after the fact.
Can be downloaded from Stephen Bullen's site.
http://www.oaltd.co.uk/MVP/Default.htm
Gord Dibben MS Excel MVP
On Sat, 14 Oct 2006 09:47:02 -0700, Abby wrote:
We have a workbook containing several sheets. Each sheet will eventually
have many named cells. When we name a cell and then hit GO TO these named
cells for ALL the worksheets show up in the list. Is there a setting we can
change so that ONLY the named cells in that particular worksheet show? If
not, then I am afraid that the only way to accomplish this is to break out
each sheet into a separate workbook, then make a master workbook that
contains links to each worksheet.