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 wrote:
>
> 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

[lindsey]

how do you do that?

"Dave Peterson" wrote:

> 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 wrote:
> >
> > 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
>

[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

lindsey wrote:
>
> how do you do that?
>
> "Dave Peterson" wrote:
>
> > 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 wrote:
> > >
> > > 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
> >

--

Dave Peterson