Tip submitted by Kieran from Western Australia.
You now have a copy of the path and the active workbook name available for all files as they are opened. Screenshot // Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"I could not get it to work in Excel 97.With right-click and draging after Help Menu,it displays a symbol (drag and copy ?) but the path does nost show aside Help menu.
Similar situation with left-click.
Any additional help ?"
How to take it away?
Followed the tip, but found that I had to LEFT (rather than RIGHT) click on the address bar. Otherwise worked fine.