ActiveWindow.Caption = "My Workbook"

or ActiveWindow.Caption = ""

8 lines is max for DV drop-downs without scrolling.

No, you cannot format the text in a DV drop-down.

For workarounds and more options using a combo-box, see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal08.html#Larger


Gord Dibben MS Excel MVP



On Mon, 14 Aug 2006 18:11:50 -0400, tx12345
wrote:


Change Work Book Caption

Hi

I have a pair of misc items.

1) At the very top of any workbook we see "Microsoft Excel -
filename.xls"

I know this will get rid of Microsoft Excel:


Code:
--------------------
Application.Caption = "My Name"
--------------------


But the file name still shows up, eg "My Name - filename.xls"

Is there a way to get rid of the file name as well?

And the second item:

I have a couple of scroll down lists from cells with validation data.
But they stop at 8. Is there a way to increase the number of items that
can be initially viewed? And can the text of the scroll down list be
formatted?

Thanks!

tx