The printed header and footer of a chart sheet where I set PageSetup settings to include them show the text nullnullnull.
I added the name of the worksheet to the CHART sheets Page Setup settings using:
When I have the created workbook open and print the entire workbook the heading and footer just contain nullnullnull centered in the header and the footer.
If I make this setting on the data sheet it works for the data sheet.
Also, if I save this as PDF instead of XLS then the chart doesn't show any header or footer. The data sheet pages do.
I have attached sample program, an xls I generated using the code that shows the problem, and an image of what the print preview shows it is going to print.