Is there anyway to do one footer and header and have it apply to the entire
workbook. I have 70 sheets I'd like to add the filename, tab and date but
didn't want to have to go into all 70 worksheets to add. I've tried in print
view for the workbook but it only did the sheet it was viewing at the time.