what drive am I in
 

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

what drive am I in
 

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 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

--

Dave Peterson

what drive am I in
 

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