'Name box'--increase width

[JRocket02]

Hi all,

Anyone know how to increase the width of the name box on the formula bar?
Tools > Customize lets you resize all boxes except this one. It is too
small to use while developing. Any help would be appreciated. Thanks!

 

[JE McGimpsey]

In MacXL, you can just use:

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

For WinXL, see

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