printing mutliple spreadsheets that are not in the same workbook

[lindsey]

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?

 

[Dave Peterson]

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.

 

[lindsey]

how do you do that?

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.

 

[Dave Peterson]

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