Unique macros trigger

H

HoundofCullin

I need help getting Excel to trigger a macros by some function other
than a keyboard shortcut. For example: Say I print one sheet of a
document. When the document is printed I'ld like it to take some of the
data on the printed document and paste in a cell on another. I believe
I know how to execute everything ther BUT the trigger.

Is it even possible to activate a macros by printing off a document?
 
J

JMay

Maybe:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
*** Your Code here***
End Sub


HoundofCullin said:
I need help getting Excel to trigger a macros by some function other
than a keyboard shortcut. For example: Say I print one sheet of a
document. When the document is printed I'ld like it to take some of the
data on the printed document and paste in a cell on another. I believe
I know how to execute everything ther BUT the trigger.

Is it even possible to activate a macros by printing off a document?
Click to expand...
creating financial statements
 
D

Don Guillett

There is a beforeprint macro but you could have a macro that

prints
does the rest after

--
Don Guillett
SalesAid Software
[email protected]
HoundofCullin said:
I need help getting Excel to trigger a macros by some function other
than a keyboard shortcut. For example: Say I print one sheet of a
document. When the document is printed I'ld like it to take some of the
data on the printed document and paste in a cell on another. I believe
I know how to execute everything ther BUT the trigger.

Is it even possible to activate a macros by printing off a document?
Click to expand...
creating financial statements
 
Top