In MacXL, enter this in the VBE's Immediate Window:

CommandBars("Formula Bar").Controls("Name Box").Width = 600

For WinXL, see

http://www.cpearson.com/excel/NameBox.htm



In article ,
"Tim" wrote:

I use Named Ranges quite a bit. The name box only shows 7
or 8 named ranges then I get a scroll bar. This scrolling
makes it difficult when I have many named ranges in a
workbook.

My question is: Can I increase the length of the Name Box
to the full screen so I don't need to scroll so much? Is
this possible?

Thanks for any assistance in the matter!