Or add the activewindow.caption

Sub bothcaptions()
Application.Caption = "MyApplication"
ActiveWindow.Caption = ""
End Sub

Gord

On Mon, 22 Dec 2003 17:33:08 -0600, Dave Peterson wrote:

I think that this is actually showing the activeworkbook's name since you have
the workbook's window maximized. I think it's excel's way of helping you.

(If you restore the workbook's window (not the application's window), to less
than maximized, you'll see that the appliation caption doesn't show the
workbook's name.

Paul James wrote:

Application.Caption = "MyNewCaption"

So that's how you do it!

Thanks (again), Vasant.

Question: I notice that when I do this, it not only puts "MyNewCaption" in
the title bar, but it also adds the filename to the string I assign to the
Caption property. In other words, it places "MyNewCaption - MyFilename.xls"
in the title bar. Is there a parameter I can add to the property assignment
that would remove the filename from the caption, and only display the
assigned string?