Microsoft Office Tutorials and References
In Depth Information
Display the Document panel
2. In the Quick Access Toolbar tab of the Excel Options dialog box, choose Commands Not
in the Ribbon from the drop-down list on the left.
3. Scroll down the list and select Document Location.
4. Click the Add button to add the selected control to the Quick Access toolbar.
5. Click OK to close the Excel Options dialog box.
Display the Document panel
Yet another way to view the path of the active workbook is to display the Document Properties
panel. Choose File
Show Document Panel. The Document Properties panel is
displayed above the Formula bar. Unfortunately, the Document Properties panel takes up quite a
bit of space, and it can’t be moved or resized.
You might want to add the Properties control to your Quick Access toolbar. See the instructions
in the previous section. In this case, choose File Tab in Step 2 and Properties in Step 3. The
Properties control toggles the Document Panel display, so you can click once to see the
workbook’s path and then click again to hide it.
Use a macro
If you’re comfortable using VBA macros, enter this Sub procedure in a VBA module in your
Personal Macro Workbook:
Sub ShowPath()
MsgBox ActiveWorkbook.Path
End Sub
Then, add the ShowPath macro to your Quick Access toolbar. When this procedure is executed,
the path of the active workbook is displayed in a message box.
Search JabSto ::

Custom Search