how to keep settings so it prints on both sides every time

I have a spreadsheet which has 2 areas for printing on both sides of a A4 sheet (front and back).It works when i select it but if i close the spreadsheet and re-open it reverts back to single side printing.I then have to change to double side printing.Is there a setting i can use which always has both sides enabled for printing even when i close the workbook?

Excel 2010

I think that the option for printing double sided is a property of your printer not of your workbook.

You could set the default for your printer to double sided but that would be for everything.

You might be able to code a beforeprint macro to set-up the printer but it depends on the printer you have. For my printer, if I want to change the printer settings I need to use sendkeys which is very messy/unreliable.