View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Perplexed of Worcs Perplexed of Worcs is offline
external usenet poster
 
Posts: 1
Default How do I change print quality for whole workbook on incomin Excel

I have already set the print quality in print manager for Excel files that I
create. I regularly receive Excel workbooks with several worksheets set to
"Best" quality print, but only require "Draft" for my purposes. I'm trying to
find a way that I can change all tabs with one command, as I currently have
to open every tab & change each set-up. With as many as 60 tabs it can become
tedious!!