J
Jack Mills
How can I add path and file name to title bar of Excel
2002 workbook? Please let me know. Thanks in advance.
2002 workbook? Please let me know. Thanks in advance.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Wilson
Jack,
Take a look at:
Application.Caption
ActiveWindow.Caption
Application.Caption = ThisWorkbook.Path & "\" & ThisWorkbook.Name
Activewindow.Caption = ""
John
Take a look at:
Application.Caption
ActiveWindow.Caption
Application.Caption = ThisWorkbook.Path & "\" & ThisWorkbook.Name
Activewindow.Caption = ""
John
J
Jack Mills
John, I'm new enough to Excel 2002 that I haven't any idea
where to start adding your suggested information to all of
my workbooks. Could you please take a minute and point me
in the right direction? Thanks in advance. Jack
where to start adding your suggested information to all of
my workbooks. Could you please take a minute and point me
in the right direction? Thanks in advance. Jack
J
Jack Mills
D
Dave Peterson
Another way of accomplishing the same functionality is to create a new workbook
that looks for you changing windows. When it sees that you did, it can change
the caption.
If you like this idea, here's a thread for you:
http://groups.google.com/[email protected]
that looks for you changing windows. When it sees that you did, it can change
the caption.
If you like this idea, here's a thread for you:
http://groups.google.com/[email protected]