View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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?