View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PP[_2_] PP[_2_] is offline
external usenet poster
 
Posts: 2
Default 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.