Editting the footer of a page in Excel using a Marco
===

Currently in my NCC class, i'm doing excel (Office 2010), and this has us printing off our work each with the same footer, and in landscape. To aid me in this i've made a macro which changes the workbook from Portrait to Landscape, however Excel / VB seems to not like editing the footer of a page with macros

Are you able to edit the footer with a macro, using possibly a VB code workaround, or otherwise?

Thanks