| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a button to print certain tabs in excel 2003 | Excel Worksheet Functions | |||
| Create Print Button on spreadsheet | Excel Worksheet Functions | |||
| A button on one sheet to print other sheets | Excel Worksheet Functions | |||
| How do I create a button to print several worksheets in Excel? | Excel Worksheet Functions | |||
| How do I create a print button? | Excel Worksheet Functions | |||
Hybrid Mode
