printing mutliple spreadsheets that are not in the same workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lindsey - 16 Dec 2005 20:40 GMT

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?

Reply to this Message

Dave Peterson - 16 Dec 2005 20:54 GMT

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 i print multiple spreadsheets at the same time, with one print
> command, that are not in the same workbook? can this be done?

Signature

Dave Peterson

Reply to this Message

lindsey - 20 Dec 2005 16:28 GMT

how do you do that?

> I don't think you can.
>
[quoted text clipped - 4 lines]
> > 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?

Reply to this Message

Dave Peterson - 20 Dec 2005 17:10 GMT

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

> how do you do that?
>
[quoted text clipped - 10 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message