Unique macros trigger

[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?

 

[JMay]

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

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?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[Don Guillett]

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

prints
does the rest after

--
Don Guillett
SalesAid Software
(e-mail address removed)

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?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[HoundofCullin]

Thanks gents... you're a coupla life savers! I am very appreciative.

Jos