Printer Multiple Worksheets with a particular Printer Setting
 

We have an issue when users are trying to print
multiple tabs off one Excel Workbook by selecting all of the tabs and the
pressing print. They then specify the settings for that particular
print run (e.g. colour, A3, landscape etc). However, when they actually
execute the job, the settings which they have applied only take effect
for the 1st tab which prints out. However, the remaining tabs of the
worksheet then print out as per the default printer settings. Is there any
way to print with settings applied by user.