printing mutliple spreadsheets that are not in the same workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i print multiple spreadsheets at the same time, with one print
command, that are not in the same workbook? can this be done?
 
I don't think you can.

Maybe you could have a macro that prints the sheets that you want from any open
workbook. You'll only have to do one thing, but it'll kind of look like you're
printing all at once.
 
how do you do that?

Dave Peterson said:
I don't think you can.

Maybe you could have a macro that prints the sheets that you want from any open
workbook. You'll only have to do one thing, but it'll kind of look like you're
printing all at once.
Click to expand...
 
Something like:

Option Explicit
Sub printall()

Dim wkbk As Workbook
Dim myWindow As Window

For Each wkbk In Application.Workbooks
For Each myWindow In wkbk.Windows
If myWindow.Visible = True Then
wkbk.PrintOut preview:=True
Exit For
End If
Next myWindow
Next wkbk
End Sub


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top