Create a Button that will print sheets
 

Hello,

I have a workbook that contains many worksheets. I would like to add a
button to my first sheet that prints a selected few of the sheets. I've
already added my button but is unsure what the code should be.

Thanks!!

Helen

Create a Button that will print sheets
 

One way...

Sheets(Array("Sheet1", "Sheet2")).printout Copies:=1
--
HTH...

Jim Thomlinson


"Helen" wrote:

Hello,

I have a workbook that contains many worksheets. I would like to add a
button to my first sheet that prints a selected few of the sheets. I've
already added my button but is unsure what the code should be.

Thanks!!

Helen

Create a Button that will print sheets
 

Works great.

Thanks!

Helen


"Jim Thomlinson" wrote in message
...
One way...

Sheets(Array("Sheet1", "Sheet2")).printout Copies:=1
--
HTH...

Jim Thomlinson


"Helen" wrote:

Hello,

I have a workbook that contains many worksheets. I would like to add a
button to my first sheet that prints a selected few of the sheets. I've
already added my button but is unsure what the code should be.

Thanks!!

Helen