Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show file location in title bar?
Is there a way to make Excel or Word show the location of a file in the title
bar. Right now, it just shows the name of the file. I was thinking in 2003, it showed the file location, or perhaps there was an option to show it? I can't find the same thing in 2007 and it would be extremely helpfull to have it! I use template files with the same name (for easy searching) but save in different client folders, which is why I want it to display the full path. Otherwise, I wouldn't care. Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show file location in title bar?
I hope I am wrong but I don't think there is a setting for that.
You can use VBA. Either workbook_open event code........... Private Sub Workbook_Open() ActiveWindow.Caption = ActiveWorkbook.FullName End Sub To clear when closing............... Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Or a toggle macro.......... 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 Alternative...............show the Web Toolbar Gord Dibben MS Excel MVP On Thu, 10 Dec 2009 11:20:01 -0800, SirMatthew wrote: Is there a way to make Excel or Word show the location of a file in the title bar. Right now, it just shows the name of the file. I was thinking in 2003, it showed the file location, or perhaps there was an option to show it? I can't find the same thing in 2007 and it would be extremely helpfull to have it! I use template files with the same name (for easy searching) but save in different client folders, which is why I want it to display the full path. Otherwise, I wouldn't care. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Bar show the location path file plus the formula | Excel Discussion (Misc queries) | |||
How to show the drive letter in the path on the title bar? | Excel Discussion (Misc queries) | |||
title bar should show document name first | Excel Discussion (Misc queries) | |||
Show full path title in title bar? | New Users to Excel | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) |