Not so serious, bite-sized articles providing information and insights into using technology in online and hybrid courses. These articles explore new and emerging technologies, pedagogy, instructional design, technology management, web accessibility, and design of assessments. This site is meant to help you become more aware of the possibilities and to spark your creativity. Laugh a little with this "light reading." Published when you least suspect it! Email: jamesfalkofske[at]yahoo[dot]com

Monday, January 12, 2015

Similar to the prior blog post about standard footers in Word documents, I also created a VBA Macro for Excel which defines my print area, adds headers and footers to the printed pages, sets the first row to repeat on all pages, and add colors to the first row in the spreadsheet (titles). It also sets the width of all the columns based on the width of the data within the column.

The variables RangeToPrint and HeadingsAtTop are automatically calculated at the time the macro is run - so it works with spreadsheet worksheets of all sizes and shapes.

I'm in a new office environment in which I'm generating lots of data reports. One of the things I have found frustrating in other environments is being handed a printed copy of a report and having no idea where the original electronic version is stored.

This VBA macro can be used to set up a standard footer in your Word documents which includes the full path and filename for the report as well as the current page out of total pages.

Now each time I create a report, I have a simple macro to run which creates a standard footer which shows others where to find the electronic version of my printed reports.

Subscribe To

About Me

Technology geek since the age of 8 (using a TRS-80 computer that saved to audio cassettes - poorly, by the way), I enjoy exploring new uses of audio, images, and video in education and training. A bit of a work-a-holic because I love what I do.