Print many worksheets

  • Thread starter Graeme at Raptup
  • 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
 
L

Lorne

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.)
 
R

Ron de Bruin

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
 
G

Graeme at Raptup

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