Hi,
I have a list box in Book1.xls which references a named range in Book2.xls.

Book2.xls is ALWAYS open before Book1.xls. I set my list box reference in
Book1 as 'Book2.xls'!MyRange - which displays the data fine.

However, when I next open Book1, the list box reference automatically shows
the full path to the named range i.e: 'C:\Program
Files\MyProgram\Book2.xls'!MyRange. I don't want it to, because the location
of the folders can change. I just always want it to reference 'Book2'!MyRange
which will always be open with it.