Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Workbook
Hi,
I've looked around and seen one answer to this that suggests a macro with a button, but I don't want to go down that route. So - how do I make excel print the whole workbook when print is selected? I have a workbook with 3 worksheets, and the users will need to print off all 3 to return to me. Rather than risk them print off only one and return that, if it auto prints all 3 I should guarantee that i get all 3 returned. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Workbook
You might try this. Put this code in your workbook's ThisWorkbook module:
Private Sub Workbook_BeforePrint(Cancel As Boolean) Worksheets.Select Application.OnTime Now, "SelectActivesheet" End Sub and put this in a standard module: Sub SelectActivesheet() ActiveSheet.Select End Sub -- Jim "smf" wrote in message ... | Hi, | | I've looked around and seen one answer to this that suggests a macro with a | button, but I don't want to go down that route. | | So - how do I make excel print the whole workbook when print is selected? | | I have a workbook with 3 worksheets, and the users will need to print off | all 3 to return to me. Rather than risk them print off only one and return | that, if it auto prints all 3 I should guarantee that i get all 3 returned. | | Thanks, | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Shared workbook losing print settings | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
changing print area in an entire workbook | Excel Worksheet Functions | |||
Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) |