Paul

Yes, you can reset it in the Auto_close code.

If you leave it blank, it will default to "Microsoft Excel"

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Caption = ""
End Sub

Gord Dibben Excel MVP

On Mon, 22 Dec 2003 15:04:59 -0800, "Paul James"
wrote:

Thanks, Gord. That's good information to have.

I'll put it in the Auto_Open sub.


Another question:

I only need the custom caption while a particular workbook is open. If I
want to reset the caption when that workbook closes, can I do that by simply
putting

Application.Caption = "Microsoft Excel"

in the Auto_Close procedure?

Thanks