In Excel 2003 and earlier, you cannot change the size of the Name box
on the formula bar. However, with some code, you can change the width
of the drop down list, the list of names that appears when you click
the arrow. See http://www.cpearson.com/Excel/NameBox.aspx for code to
widen the drop down.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 2 Dec 2008 11:51:01 -0800, Lois
wrote:

How to change the size of the 'Name Box'.. ie make it wider