Widen name box
 

How do I widen the name box ?
I have (a few) ranges who's name is longer than my actual name box.
Tx

Widen name box
 

I think the name boxes are actually text boxes. You ned to enter Design Mode
to change the sizes of textt boxes.

1) View - Toolbars - Control Toolbox
2) Click the Triangle Icon (Design Mode) to enter Design Mode. this is a
toggle button which enters/exits Design Mode
3) Click the Name box and you should see the sizing button for the box
appear. Change size as required
4) Click on triangle Icon again to exit Design Mode.

"Gilbert DE CEULAER" wrote:

How do I widen the name box ?
I have (a few) ranges who's name is longer than my actual name box.
Tx

Widen name box
 

Check here (Watch word wrapping)

http://groups.google.com/group/micro...f84d 1facec1f

"Gilbert DE CEULAER" wrote:

How do I widen the name box ?
I have (a few) ranges who's name is longer than my actual name box.
Tx

Widen name box
 

See' Chip Pearson's' (http://www.cpearson.com/excel/NameBox.aspx)
solution


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=41830