View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default 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