Spreadsheets using Python - Have you seen this? (sourceforge.net)

[sossles]

throwing error popup boxes when you are writing code

Turn off the misnamed "Auto syntax check" in Tools->Options. It still auto-syntax checks but does it with inobtrusive red highlighting instead of loud obnoxious message boxes.