| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedded button print macro
i'm trying to program a button to print selected worksheets from an excel file:
Private Sub CommandButton1_Click() Range("Summary!, 'IRR Summary'!, 'Presentation Cash Flow'!, 'Rent Roll'!, Vacancy!, 'Economic Rent'!").Select ActiveWindow.ActiveSheets.PrintOut Copies:=1, Collate:=True End Sub luch to anyone in the LA area who can help me out!!! THANKS |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Embedded button print macro
something like:
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintPreview Regards Trevor "grantfeek" wrote in message ... i'm trying to program a button to print selected worksheets from an excel file: Private Sub CommandButton1_Click() Range("Summary!, 'IRR Summary'!, 'Presentation Cash Flow'!, 'Rent Roll'!, Vacancy!, 'Economic Rent'!").Select ActiveWindow.ActiveSheets.PrintOut Copies:=1, Collate:=True End Sub luch to anyone in the LA area who can help me out!!! THANKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button - Macro to print to pdf, then send pdf to email. | Excel Discussion (Misc queries) | |||
| How do I remove a "Print Report" button embedded on spreadsheet? | Excel Discussion (Misc queries) | |||
| print button macro & specific tabs to print | Excel Worksheet Functions | |||
| Print MAcro Button | Excel Discussion (Misc queries) | |||
| A Print Button macro that is based on Checkbox macros | Excel Programming | |||
Linear Mode
