Running a macro/code when Excel starts.. 1

[simmantix]

Dear all,

I wish to run a piece of VBA code every time Excel starts..

E.g. - objExcel()_OnStart

CODE

I know this is the incorrect syntax/form/etc, anyone got any better ideas?? All I want to do is delete some values and formatting every time the program comes up..

Thanks

 

[kayah]

Put these lines on the "ThisWorkbook" code sheet (not as a module):

Private Sub Workbook_Open()
CODE
End Sub

 

[simmantix]

Thankyou..