Can the full path be shown in the Title Bar?
mark
Only through VBA and does not stick through sessions so has to be reset.
Private Sub Workbook_Open()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Caption = ""
End Sub
Paste these Subs to the ThisWorkbook module.
Could also be placed in Personal.xls or an Add-in that loads when Excel is
started.
Gord Dibben Excel MVP
On Tue, 22 Nov 2005 09:28:12 -0800, markvi
wrote:
Is there a way in Excel 2003 and Windows XP to have the application's Title
Bar show the full path of the document and not just the file name?
|