Change headers and footers in excel when printing
Posted on 2012-03-15
I have an excel file with headers and footers, i need to print the same excel in two ways, one with the headers anf footers and the other without them.
I have done a macro that takes out the headers and put only de left and right footer, but when I user it, it changes all de print properties of all de pages that i have to print, some of them are landscape and the macro change them.
I need a way to do it, do you know if it is possible?
Thanks, and sorry for may english is not very good