naming range

[Tory]

Hi,
I have many worksheets in a workbook and I tried to define a name for
one worksheet only. For some reason, after I defined it(by selecting
the range and typing a name in the range name textbox), this name shows
up in other worksheets as well. Also in the ‘Define Name’ dialog box,
the worksheet name does not show up next to the range name. What do I
do so it shows up? How do I define a name that’s unique only to one
worksheet?
Thanks.

 

[J.E. McGimpsey]

to define a sheet-level name, prefix the name with the Sheet name
when you enter it in the name box, e.g.:

Sheet1!myname