I have a workbook that has 6 worksheets. I have VBA code to print different names as a footer on each page of the first worksheet. I have the code disabled, however when I attempt to print a different worksheet on the same workbook, although on the preview pane it shows the correct worksheet...