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

G

Guest

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
 
G

Guest

Dr. Crowbar,

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

Guest

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

Guest

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

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I merge 2 worksheets into one consolidated worksheet? 1
How do I print a specific worksheet everytime? 1
Print Multiple Sheets to PDF Problem 3
how do i print two workbook sheets onto one page side by side? 1
Excel print area which only prints pages of worksheet which are active 0
How do I set print areas for multiple sheets simultaneously? 3
How Do I Automatically Link New Spreadsheets to One Master File? 3
how do I print multiple print areas on one page 1

Top