Nec11
04-29-2013, 05:15 AM
Hello to all!
It is any possibility to fins an "AfterPrint" event enabler.
The problem is that I have an excel table with "Sheet1" where I insert some values, and on "Sheet2" an Pivot table. After printing the pivot table I need to save the eralier inserted dates in "Sheet3" to keep hisory of movements.
The problem is that I have managed to select "Sheet1"/copy"Sheet1"/paste to "Sheet3" via an VBA liked to an Button.
I need to do this via VBA code.
Any ideea?
Thank you in advance
It is any possibility to fins an "AfterPrint" event enabler.
The problem is that I have an excel table with "Sheet1" where I insert some values, and on "Sheet2" an Pivot table. After printing the pivot table I need to save the eralier inserted dates in "Sheet3" to keep hisory of movements.
The problem is that I have managed to select "Sheet1"/copy"Sheet1"/paste to "Sheet3" via an VBA liked to an Button.
I need to do this via VBA code.
Any ideea?
Thank you in advance