Hello.

I currently have a workbook with several worksheets. Having run the first part of the macro, only some of the worksheets contain data.

The second part of the macro determines which worksheets have data, and then automatically prints the relevant pages. My problem is that our network settings have changed in two ways:
1) It prevents us from permenanlty selecting 'Hold Print' from the preferences.
2) It automatically selects duplex printing.

Each of the sheets printed need to be held and without duplex. Before I print, it is possible to manually change the settings but they work only for the first worksheet, each one thereafter is printed duplex etc. Is there a macro that allows Excel to take control of the print settings throughout the entire print run?

Thanks

Darren