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
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
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks