Lou

A macro attached to a button will toggle that on/off

Sub CaptionToggle()
' toggles title bar between document name and full path
If ActiveWindow.Caption = ActiveWorkbook.Name Then
ActiveWindow.Caption = ActiveWorkbook.FullName
Else: ActiveWindow.Caption = ActiveWorkbook.Name
End If
End Sub

You could have event code in a workbook if you wanted, but that would be
specifically for that workbook.

Private Sub Workbook_Open()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub

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


Gord Dibben MS Excel MVP

On Wed, 18 Jul 2007 16:34:01 -0700, Lou wrote:

At the very top of the screen where the current file name is, it does not
indicate what drive I am in. (Hard drive, flash drive, etc) How can I tell
where I am.

In Word Perfect and Quatro Pro it always shows which drive you in. How come
no Microsoft?

Lou