View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T & I Forms T & I Forms is offline
external usenet poster
 
Posts: 1
Default Print selected worksheets in multiple workbooks?

We would like to print two specific worksheets that exist in multiple
workbooks at the same time. In other words, we would like to be able to
select all workbook files in a directory and send to the printer to have the
same two pages from each workbook print, not the entire workbook. We would
like to avoid having to select each file individually to send two sheets to
the printer, and then close and go on to the next file. Is this possible, and
if so, how do we accomplish this? Thanks for any direction you can provide.