software

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.

lindsey wrote:
gt;
gt; how do i print multiple spreadsheets at the same time, with one print
gt; command, that are not in the same workbook? can this be done?

--

Dave Peterson

how do you do that?

quot;Dave Petersonquot; wrote:

gt; I don't think you can.
gt;
gt; Maybe you could have a macro that prints the sheets that you want from any open
gt; workbook. You'll only have to do one thing, but it'll kind of look like you're
gt; printing all at once.
gt;
gt; lindsey wrote:
gt; gt;
gt; gt; how do i print multiple spreadsheets at the same time, with one print
gt; gt; command, that are not in the same workbook? can this be done?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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 SubIf you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

lindsey wrote:
gt;
gt; how do you do that?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I don't think you can.
gt; gt;
gt; gt; Maybe you could have a macro that prints the sheets that you want from any open
gt; gt; workbook. You'll only have to do one thing, but it'll kind of look like you're
gt; gt; printing all at once.
gt; gt;
gt; gt; lindsey wrote:
gt; gt; gt;
gt; gt; gt; how do i print multiple spreadsheets at the same time, with one print
gt; gt; gt; command, that are not in the same workbook? can this be done?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson