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


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=571587