Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Display Full Path for File Diplayed at Top Of Workbook
Excel 2000 is just displaying the file name in the top header of the
workbook. Can it be set up to show the full path with the file name ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Display Full Path for File Diplayed at Top Of Workbook
With some VBA, yes.
Private Sub Workbook_Open() ActiveWindow.Caption = ActiveWorkbook.FullName End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Or selectable................ 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 Gord Dibben MS Excel MVP On Thu, 1 Feb 2007 11:59:00 -0800, XRacr wrote: Excel 2000 is just displaying the file name in the top header of the workbook. Can it be set up to show the full path with the file name ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i display the Filename without the path? | Excel Discussion (Misc queries) | |||
One workbook to another . . . | Excel Discussion (Misc queries) | |||
full UNC path in footer | Excel Discussion (Misc queries) | |||
how do I display a worksheeet in full screen view | Excel Discussion (Misc queries) | |||
Cannot display Workbook | Excel Discussion (Misc queries) |