I need a macro to keep recalculating over and over

[qbertmail]

I have actually found a macro to do the recalculating, but I can't get it to run when the worksheet is opened. I tried to copy it in an open module, but can't get the syntax right. I am pretty new to this. Thanks

 

[Norie]

Can you post the code?

Where did you try putting the code?

Did it work at all?

 

[qbertmail]

Here's what I have

Private Sub Workbook_Open()
Calculate
Application.OnTime earliesttime:=Now + TimeValue("00:00:01"), _
procedure:="Recalculate"
End Sub

it says that it can't find file ....recalculate

 

[qbertmail]

Re: Here's what I have

Private Sub Workbook_Open()
Calculate
Application.OnTime earliesttime:=Now + TimeValue("00:00:01"), _
procedure:="Recalculate"
End Sub

it says that it can't find file ....recalculate

Also, is it possible to make it recalculate more often than every second?