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

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

Works great.

Thanks!

Helen


"Jim Thomlinson" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
>>