Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/general-topics-in-vba/inserting-the-path-where-the-workbook-is-saved-to-the-title-bar-or-the-status-bar-using-vba-in-microsoft-excel.html
SHARE




The blue line at the top of the window is the Title bar. Use the available empty space by adding information such as the Path, which shows where the active workbook is saved.

To add the path address to the Title bar:

1. Press Alt+F11 to open the VBE.
2. In the VBAProject pane, double-click ThisWorkbook.
3. At the top of the Module, open the left dropdown list (General) and select Workbook, then select the Activate event from the Procedure dropdown list on the right.
4. In the Activate macro, type the following code:
Application.Caption=ThisWorkbook.Path
5. To cancel the displaying of the path when activating or opening a different workbook, add the Deactivate macro by selecting Deactivate from the Procedure dropdown list.
6. In the Deactivate macro, type the code:
Application.Caption=” ”
7. Copy and insert the two macros to each This Workbook module of any workbook for which you wish to display the path.

Screenshot // Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel
Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft ExcelInserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel

Please follow and like us:
0


8 thoughts on “Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel

  1. How can have the path saved to the status bar automatically for all workbooks? When I created the macro, it was specific to the current workbook?b

  2. “Another method (works for those ‘other’ products Word and PowerPoint too) is to :
    1. Open the web toolbar.
    2. Whilst holding down CTRL and ALT, right-click on the address control and drag up to the menu bar just after the Help menu.
    You now have a copy of the filename available for all files as they are opened.

    It does not get the file name in the application name as for the original tip, but it does avoid eachfile needing to contian a macro.”

  3. I just wanna create macro to copy a figure in particular column in first sheet and to find the same number (which I copied from sheet 1) in Sheet 2. The problem I am facing is excel is creating Macro to find the specific value, but if I change the values then it is not working. Please help me.

  4. There are a number of ways to search for data in this fashion. In the macro, create a named variable, then pick up the data you want to find by storing it’s value in the variable. then use the Variable as the search criteria on the second sheet.

  5. “Hello,

    If you are looking for a great book on the subject of VBA and Macros, check out Writing Excel Macros with VBA, 2nd Edition”

  6. “Hi,

    I want to change the values of the selected region on the sheet.

    How to access the values of the same region.

    Aditya Datar “

Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>