Excel 2007 - Macro when printing to include row $1:$1

[Johnny Thunder]

Hello all,


I have a workbook that I have multiple tabs with data. Each month I have a macro that looks into all tabs except the master report and deletes all contents in each tab. Unfortunatlly this also removes all the print settings like when I tell each tab to always include Row $1:$1.

Is there a macro that I could put in that will always print row 1:1 when a print from any tab?

Thanks in advance for your help.