Hi Marc,
Is your SumSheets() function volatile?
To make it volatile you can add the following single line of code...

Application.Volatile

Make it the first line of code after the Function SumSheets() top line.

Hope this helps.

Ken Johnson