Run Command When Push Print Button?

[DaTrusHurtz]

Hi,

The title pretty much summarizes my question. Is there a way to make excel automatically run a script when the user pushes the print button?

What I'm trying to do is, when someone opens my file and they push the print button, it changes colors of text.

Thanks!

[lucas]

Put the before print procedure in the thisworkbook module:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
'do your formatting here....
End Sub