#CREATE A MACRO TO INSERT FILE NAME IN WORD HOW TO#
How to show File Path in Title Bar in Microsoft Word
Read: How to change default Excel worksheet direction from right to left. But for this, first, you have to open the Macro-enabled spreadsheet, otherwise, your Macro will not be shown in the Macros list.
Now, you can display the complete file path in any Excel Spreadsheet by running the Macro you have created. After that, Excel will show the complete file path in the Title Bar of that spreadsheet. Click Macro, select the Macro from the list, and click Run. If you see a Security Warning ribbon, click Enable Content. Now, open an Excel Spreadsheet and select the Developer tab. Click Save.ĥ] You have created a Macro to display the file path in the Title Bar in Excel spreadsheets. After that, give a name to your Excel file and Excel Macro-Enabled Workbook in Save type. Go to “ File > Save” and select the location to save the Excel file. ActiveWindow.Caption = ActiveWorkbook.FullNameĤ] Go to “ File > Save” and close the Visual Basic window. This will open the Microsoft Visual Basic window.ģ] Now, copy the following command, go to the Microsoft Visual Basic window, and paste it between Sub and End Sub (refer to the above screenshot). Do note that the words in the Macro’s name should not be separated by a space. The Options Menu is the easiest method to enable the Developer tab in Excel.Ģ] After enabling the Developer tab, select it and then click Macros. You can follow any of the following options to enable the Developer tab in Excel: Therefore, if you have not enabled it before, enable it first. By default, the Developer tab is disabled in Microsoft Excel.
When we create a new document or spreadsheet, its default name is shown on the Title Bar. When we open a document in Word or a spreadsheet in Excel, its name is displayed on the Title Bar of Word and Excel respectively.