How do I Print Multiple worksheet contained under one file name?

D

Dr. Crowbar

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
 
P

papou

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

Cordially
Pascal
 
D

Dominic LeVasseur

Dr. Crowbar,

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

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.
 
D

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.
 
D

Dominic LeVasseur

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?
 
Top