How to epand size RangeName Box

[Jay_44]

Using either Excel 2000 or 2002

On Excel's standard menu bar, can the NameRange box be sized?

If no, can a customized button that is sizable be written using Excell
DLL call to the NameRange box object?

 

[Chip Pearson]

Jay,

You can do this with a few API calls. See www.cpearson.com/excel/NameBox.htm
for details.

 

[Jay_44]

Chip,

Thanks - very cool.