BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 26 January 2017
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Showing Excel Workbook paths in the quick access toolbar
It can be useful (particularly if you're writing VBA to open, save and close files) to be able to get at a workbook's location easily:
You can tell Excel to display the file location permanently.
To do this, customise the quick access toolbar. First right-click on it and choose to customise it:
Right-click on one of the existing tools in your quick access toolbar, and choose this menu option.
Now choose All Commands from the drop list which appears:
Choose from the list of all Excel commands.
Scroll down (a fair way) to Document Location, and double-click on this to transfer it into your quick access toolbar:
Alternatively, you can click on the Add >> button shown.
Choose OK - every file in Excel from now on will have its path displayed:
You can copy the file path at any time.
My thanks to Jacqueline of Lloyd's for this tip!