How to auto run vb macro when the excel file is open

[mhanaan]

The macro only works when placed into a module, ive still not found a a way to get around this, would appreciate if you could help solve this issue and also get the macro to start when the file is open:

The following code is placed in a module:
Dim TimerActive As Boolean
Sub StartTimer()
Start_Timer
End Sub
Private Sub Start_Timer()
TimerActive = True
Application.OnTime Now() + TimeValue("00:00:01"), "Timer"
End Sub
Private Sub Stop_Timer()
TimerActive = False
End Sub
Private Sub Timer()
If TimerActive Then
ActiveSheet.Cells(2, 2).Value = Time
Application.OnTime Now() + TimeValue("00:00:01"), "Timer"
End If
End Sub

Thanks in advance..

 

[Joe4]

Place it in a Workbook_Open event procedure. See here for instructions on how to do that.
http://support.microsoft.com/kb/265113

Note you cannot change the name of the macro! It must be named exactly as shown to work.