Here's our Microsoft Office Tip for.. May 21, 2001
Click Here to see a complete list of all of our previously released Tips!
Printing the Workbook Path in a Header
Some people find printing the workbook's name in a footer helpful. Doing so creates a quick reference for the file's location on your printout. However, there's no built-in feature for printing the file's name, but you can do so with a simple macro. To create this macro, open the VB Editor by clicking Alt-F11. Then, select the correct project in the Project window (which you'll find in the upper-left corner). Next, select Insert, Module. In that module, enter the following procedure:
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
To close the VB Editor, simply click the Close button at the top-right corner of your screen.
When you're ready to run the macro, choose Tools, Macro. Then, choose Macros again, select NameInFooter, and click Run. You won't see the effects immediately. If you click the Print Preview button, you can see the filename in the footer.