Printer Multiple Worksheets with a particular Printer Setting

Printer Multiple Worksheets with a particular Printer Setting

Post by UFA » Thu, 15 Mar 2007 23:02:16


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.