G
Guest
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.
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.