Print many worksheets
 

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

Thanks,

Graeme

Print many worksheets
 

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

Thanks,

Graeme

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

Print many worksheets
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

Thanks,

Graeme

Print many worksheets
 

Thanks,
I ended up using Sheets(Array(....



"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

Thanks,

Graeme