How do you print double-sided on multiple worksheets in excel?

I have an Excel file with multiple worksheets. I want to print each worksheet double-sided (duplex) to a Canon photocopier without having to change the settings for each worksheet. Even with a macro, I get the first worksheet to print double-sided but all subsequent ones are single-sided. There are 26 worksheets that I need to print double-sided. The worksheets cannot be combined into one worksheet.