Resize name box

[Gilbert De Ceulaer]

Hi !
Is it possible to make the Name Box wider ?
I have some range-names that are larger than the box, and differ only in the
last letter, so I can not alway see the entire name.
TIA,
Gilbert De Ceulaer

 

[JE McGimpsey]

In MacXL, enter this in the VBE Immediate Window:

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

For WinXL, see

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

 

[Bob Phillips]

Hi Gilbert,

Go take a look at http://www.xldynamic.com/source/xld.Names.html#misc

--

HTH

RP
(remove nothere from the email address if mailing direct)