Auto macro

[BDavis]

Hey,

I using a bit of simple code stored as a module to creat
headers based on cell values. This is fine but it there a
way to store the code so that it runs itself inthe
backgraound with out me having to manually execute the
macro?

 

[Paul B]

BDavis, you could put it in the before print code in thisworkbook code, like
this

Private Sub Workbook_BeforePrint(Cancel As Boolean)
'your code here
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003