what drive am I in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top