Resize name box

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

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



In article <##HNj#[email protected]>,
"Gilbert De Ceulaer" <[email protected]> wrote:

> 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.

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)


"Gilbert De Ceulaer" <[email protected]> wrote in message
news:%23%23HNj%[email protected]...
> 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
>
>