what drive am I in

[Lou]

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

 

[Dave Peterson]

Click on File|Properties and look at the general tab.

Or put this in an empty cell:
=cell("filename",a1)

The workbook has to be saved for that formula to work.

 

[Gord Dibben]

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