My thinking is it would have to be VBA code of some sort. The current
header and footer options are under PAGE setup; hence this affect the
workbook and net a specific worksheet.

Good luck.