How do I expand the Name Box?

[JohnnyQuick]

When I name a range, it is posted to the Name Box (next to the formula bar).
However, the full name is not displayed due to the size of the name box.
Thanks.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Names.html#misc

 

[Chip Pearson]

You can do this only through code. See
http://www.cpearson.com/excel/NameBox.htm for details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[JohnnyQuick]

Thanks Chip. I appreciate it!

You can do this only through code. See
http://www.cpearson.com/excel/NameBox.htm for details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message

 

[JohnnyQuick]

Thanks Bob. Both you and Chip gave me the solution.