Worksheet_Calculate problem

[josthkko]

I am puzzled with this, but i reckon it has a very simple solution..
When i open a new excel workbook and write the code into the Worksheet_Calculate Sub and connect gruss to that workbook, the code doesn't execute on calculation, and if i click run they execute only once.
I have one older workbook that i have created a couple of months ago and it works fine.
Could someone please explain which settings am I missing?

Thank you!

[Captain Sensible]

Bit hard to second guess without the code, do you have a line within the code turning off Application.EnableEvents= False ? It's possible it's not being turned back on again possibly in some loop

Application.EnableEvents = True.

Does the code refer to a specific worksheet ? Try saving the file and reopening it

[josthkko]

No, i have made this code just for testing purposes:

Private Sub Worksheet_Calculate()
List1.Cells(24, 5) = 1243
End Sub

And when i press run it writes that number in that cell but after i delete it doesn't write it again automatically, just if i press run again, so the code shouldn't be the problem, I would say it's some settings in excel. The sheets that are in examples here on the page work perfectly also.
I'm having problems just if i open a new file, but for the life of me i don't know what am i doing wrong.

[GaryRussell]

Have you got any formulas in your spreadsheet to trigger the calculate event? If there aren't any formulas referencing the cells that are being updated by Betting Assistant (or your code) then the event will not fire because nothing is being calculated. For example put =F5 in cell R5 and it should start working.

[josthkko]

Yes, that solved it! I just had the VB code but no formulas.

Thank you very much!