Change size of name box

[Gilbert De Ceulaer]

Is it possible to change the size of the name box ? And how do you do it ?
Some of my range's names are to long to fit in the actual name box.
Thanks in Advance, and may all of you have a healthy 2004
Gilbert

 

[Gord Dibben]

Gilbert

Not without some coding.

You can download........

Robert Gelb's NameBoxResizer:
http://www.vbrad.com/pf.asp?p=Source/src_xl_nb_addin.htm
(for xl2k and above, but there's a link that points to an xl97 version)

And Chip Pearson has a version at:
http://www.cpearson.com/excel/NameBox.htm

Gord Dibben Excel MVP

 

[Charles Williams]

An alternative or extra is to use Name Manager, which handles long names
(and long refersto) together with a lot of additional facilities for
handling names
http://www.decisionModels.com/downloads.htm


Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm