Modifying excel NameBox size

[mikajake]

Is there anyway to modify the namebox in the top left of the window to display the full name of a named range. I am trying to record a macro/macros and it is difficult when I can't see the full name, thus avoiding picking the wrong range and have to edit the macro later?

Thanks

 

[Greg Truby]

Only way I've ever seen http://www.cpearson.com/excel/NameBox.htm

 

[Ivan F Moala]

Or here for a more in depth explanation and also how to get the class names ....

http://www.xcelfiles.com/Excel01_01.html