Home |
Search |
Today's Posts |
#1
|
|||
|
|||
print property
Is there anyway to put code behind the print button.
I want the program to auto select ranges and print off that area when the print button is pressed without having to go in a set the , print area, page setup, fit to one page for four different parts of a worksheet. Is this possible? Thanks, |
#2
|
|||
|
|||
Right-click the excel LOGO near the File menu, select View Code, on the left
dropdown select Workbook, in the right dropdown, select Before Print, and enter whatever code you want there. The stub is: Private Sub Workbook_BeforePrint(Cancel As Boolean) End Sub Bob Umlas Excel MVP "cwwolfdog" wrote in message ... Is there anyway to put code behind the print button. I want the program to auto select ranges and print off that area when the print button is pressed without having to go in a set the , print area, page setup, fit to one page for four different parts of a worksheet. Is this possible? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel |