Change Work Book Caption

[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

 

[Gord Dibben]

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

 

[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

 

[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

 

[CLR]

Maybe here..........

http://www.danielklann.com/excel/change_xl_icon.htm

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Thanks Chuck

Finally an answer to this question.

Good find.


Gord

 

[Guest]

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