View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ehale ehale is offline
external usenet poster
 
Posts: 8
Default Print All Sheets-Select Printer First


Hello,

I am using the following code to print all sheets in a workbook, but want
the user to select a printer first. Not sure how to accomplish this. Any
help is very appreciated!

Application.ScreenUpdating = False

Sheets(Array("ACCOUNT SUMMARY", "VEHICLES", "DRIVERS", "AUTO LIMITS",
"GENERAL LIAB", "QUOTE")).PrintOut , , 1

Sheet1.PrintOut , , 1
Application.ScreenUpdating = True

Thanks,
Erica