Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Path name for a file
"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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Path name for a file
Cool
I want to Folder options and checked Display full path name in Address Bar Display full path name in Title bar Lou " wrote: "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |