J
jllaclair
"Show path name in Title Bar for Excel"
Step 1: Open Excel
Step 2: ALT-F11 (this will open visual basic editor)
Step 3: Click View, Properties Window
Step 4: Next to NAME - Module1 (click on Module1 and rename to
ChangeCaption )
Step 5: Click Insert Module
Sub ChangeCaption()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub
Copy or type the above starting with SUB and ending with SUB
And paste into the Module
Step 6: Click File, Save book1, and save the file on your C drive in My
Documents folder
Step 7: Click the X on the Microsoft Visual Basic to close the program
(you should now be back on the Excel Program)
Step 8: Click VIEW, TOOLBARS, CUSTOMIZE, click COMMANDS tab and scroll
down to Macros
Step 9: Click on the SMILE face and hold the mouse button down and drag
up to your toolbar, let go of mouse button (smile face should be on
toolbar now), Click CLOSE.
Step 10: Click SMILE face, click on
BOOK1.XLS!changecaption.changecaption, Click OK,
Now click on Smile face anytime you wish to know the path of the file
you are currently working on.
Security - You mave have to edit security settings so that you can
run the macro, to do this, Click Tools, Options, Security Tab, Macro
Security, Click MEDIUM, click OK, OK.
Thought this might be useful... hard to find info on this.
Step 1: Open Excel
Step 2: ALT-F11 (this will open visual basic editor)
Step 3: Click View, Properties Window
Step 4: Next to NAME - Module1 (click on Module1 and rename to
ChangeCaption )
Step 5: Click Insert Module
Sub ChangeCaption()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub
Copy or type the above starting with SUB and ending with SUB
And paste into the Module
Step 6: Click File, Save book1, and save the file on your C drive in My
Documents folder
Step 7: Click the X on the Microsoft Visual Basic to close the program
(you should now be back on the Excel Program)
Step 8: Click VIEW, TOOLBARS, CUSTOMIZE, click COMMANDS tab and scroll
down to Macros
Step 9: Click on the SMILE face and hold the mouse button down and drag
up to your toolbar, let go of mouse button (smile face should be on
toolbar now), Click CLOSE.
Step 10: Click SMILE face, click on
BOOK1.XLS!changecaption.changecaption, Click OK,
Now click on Smile face anytime you wish to know the path of the file
you are currently working on.
Security - You mave have to edit security settings so that you can
run the macro, to do this, Click Tools, Options, Security Tab, Macro
Security, Click MEDIUM, click OK, OK.
Thought this might be useful... hard to find info on this.