Change Work Book Caption

T

tx12345

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
 
T

tx12345

Thanks for the tip.

Do you know how to change the little excel image icons in the upper
left hand corner (two of them)?

Thanks again!

tx
 
G

Gord Dibben

Have not heard of a method to get rid of the image icons.

Question has been asked many times but never seen a reply other than the above.


Gord
 
C

CLR

You're welcome Gord..........Lucky find, just happened to Google-it the right
way for once.......<G>......actually, now that I've got it, I think I'll
start using it for some of my custom programs.......what the hey!.........

Vaya con Dios,
Chuck, CABGx3
 
Top