I have a number of budget worketsheets tabbed under a file named "Budget
Master" I would like to print them all simultaneously(a single execution of
the print command). However, I can't get the print range to set up alike
for all sheets to be printed when I highlight multiple tabs to be printed.

Any help would be appreciated

Dr. Crowbar

Hello
Dim wsh As Worksheet
For Each wsh In Sheets
wsh.PageSetup.PrintArea = "A1:B10"
wsh.PrintOut
Next wsh

Cordially
Pascal

"Dr. Crowbar" a écrit dans le message
de news: ...
I have a number of budget worketsheets tabbed under a file named "Budget
Master" I would like to print them all simultaneously(a single execution
of
the print command). However, I can't get the print range to set up alike
for all sheets to be printed when I highlight multiple tabs to be printed.

Any help would be appreciated

Dr. Crowbar

Dr. Crowbar,

Does the "Entire Workbook" setting under "Print What" in the Print dialog
box work for you?




"Dr. Crowbar" wrote:

I have a number of budget worketsheets tabbed under a file named "Budget
Master" I would like to print them all simultaneously(a single execution of
the print command). However, I can't get the print range to set up alike
for all sheets to be printed when I highlight multiple tabs to be printed.

Any help would be appreciated

Dr. Crowbar

Dominic,
I don't see the "Entire Workbook" setting in the "print setup" option. There
are "Page" choice options but I want to but am unable to set the range
simultaneously for all worksheets under the single file name.

"Dominic LeVasseur" wrote:

Dr. Crowbar,

Does the "Entire Workbook" setting under "Print What" in the Print dialog
box work for you?




"Dr. Crowbar" wrote:

I have a number of budget worketsheets tabbed under a file named "Budget
Master" I would like to print them all simultaneously(a single execution of
the print command). However, I can't get the print range to set up alike
for all sheets to be printed when I highlight multiple tabs to be printed.

Any help would be appreciated

Dr. Crowbar

Pascal,
I am not familiar with these instructions but will contact some of my
associates here to help me out w/this.

Thank you so much for the input.

"papou" wrote:

Hello
Dim wsh As Worksheet
For Each wsh In Sheets
wsh.PageSetup.PrintArea = "A1:B10"
wsh.PrintOut
Next wsh

Cordially
Pascal

"Dr. Crowbar" a écrit dans le message
de news: ...
I have a number of budget worketsheets tabbed under a file named "Budget
Master" I would like to print them all simultaneously(a single execution
of
the print command). However, I can't get the print range to set up alike
for all sheets to be printed when I highlight multiple tabs to be printed.

Any help would be appreciated

Dr. Crowbar

Hmmm

What version of Excel are you using?

I have Excel 2000.

When I click File:Print from the menu bar - I am taken to the Print dialog
box.

In the bottom left corner of the dialog box, there are three radio buttons
labeled,
"Selection", "Entire Workbook", "Active sheet(s)", with Active Sheets being
the default.

Do you not have these options in the Print Dialog box that comes up after
clicking File:Print from the menu bar?



"Dr. Crowbar" wrote:

Dominic,
I don't see the "Entire Workbook" setting in the "print setup" option. There
are "Page" choice options but I want to but am unable to set the range
simultaneously for all worksheets under the single file name.

"Dominic LeVasseur" wrote:

Dr. Crowbar,

Does the "Entire Workbook" setting under "Print What" in the Print dialog
box work for you?




"Dr. Crowbar" wrote:

I have a number of budget worketsheets tabbed under a file named "Budget
Master" I would like to print them all simultaneously(a single execution of
the print command). However, I can't get the print range to set up alike
for all sheets to be printed when I highlight multiple tabs to be printed.

Any help would be appreciated

Dr. Crowbar