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
|