Print many worksheets

  • Thread starter Thread starter Graeme at Raptup
  • Start date Start date
G

Graeme at Raptup

Hi,
I want to add a button that prints many, but not all, worksheets.
How do I go about this?

Thanks,

Graeme
 
Graeme at Raptup said:
Hi,
I want to add a button that prints many, but not all, worksheets.
How do I go about this?

Thanks,

Graeme
Click to expand...

Turn macro recording on, do what you want to do manually, turn macro
recording off. You can now add a button to the menu and assign this macro
to the button.

(press F11 to look at the VB code created in case you need to modify it.)
 
Hi Graeme

You can use a array

Sheets(Array("Sheet1", "Sheet3")).PrintOut
'all sheets in the array

Or print the selected sheets

ActiveWindow.SelectedSheets.PrintOut
'print all selected sheets
 
Thanks,
I ended up using Sheets(Array(....



Ron de Bruin said:
Hi Graeme

You can use a array

Sheets(Array("Sheet1", "Sheet3")).PrintOut
'all sheets in the array

Or print the selected sheets

ActiveWindow.SelectedSheets.PrintOut
'print all selected sheets
Click to expand...
 
You must log in or register to reply here.

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

Excel VBA - Problem with Closing Print Preview 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Hide row before printing 3
Print on only one page 5
Recovering File Info Specifically Save Date or Print Date 4
how do I print multiple print areas on one page 1
Excel Fit to page print options in Excel 1
Problem printing all worksheets in colour 1

Back
Top