formula toolbar

[gerry]

does anyone know how to resize the formula toolbar? I
actually am trying to widen the "NAME dropdown as it is
part of the formula toolbar.

The formula toolbar is not customizable under the tools
customize toolbar command.

 

[Dave Peterson]

Depends on the version of excel you're running:

Robert Gelb's versions:
http://www.vbrad.com/pf.asp?p=Source/src_excel_namebox.htm

or

Chip Pearson's:
http://www.cpearson.com/excel/NameBox.htm

 

[gerry]

Thanks a bunch. Looks like vbrad is good for 2000 and
cpearson for 2002. I have 2002. let me know if you this
is how you see it.

How do you find this stuff??

 

[Dave Peterson]

I found it in the newsgroup.

I liked Chip's better and copied his code into my Personal.xla workbook.

I use that workbook for both xl2k and xl2003.