How do I stop calculation??

Hi all,
I'm using Excel 2007. In Forumulas ribbon, Calculation Options, I have Manual set.
Yet whenever I paste code into the workbook's vb module, or when I cut/insert columns or anything like that, the entire sheet recalculates. Isn't that what the "manual" option is supposed to prevent?

If that's not what that option is for, can anyone tell me how to disable any calculations until I give it the go-ahead?

Thanks,
--Jim

Hi all and thanks for the replys.
Here's what I did to recreate:

First, nothing in any Change event.

All I need to do to recreate this is copy a function in the module, paste it and change it's name, then hit Save and the calculation starts. Save does not force calculation in any other situation--I can add data to cells, add forumulas to cells, etc. then hit Save and no Recalc. But adding or changing a function--that forces a recalc.

This is a bad thing because as I'm writing code, I'm in the habit of hitting Save every few minutes (this is force of habit due to years of MS instability where apps would crash at random and I'd lose code--lose a few hours worth of prime code just once and you'll wear the paint off that Save button quickly!)

So anyway...I'm guessing I'm screwed here unless anyone knows some possibly undocumented setting that disables forced recalc on code changes. But I've got to believe other people would have come across this.

Another bit of useful info...I do have an xlam file attached to my Excel startup, it's a Linear Math app callled Lindo What's Best. But I'm not changing any cell or anything but my own module code when this recalc occurs so I still can't see where this would have any effect. There isn't a timer-controlled recalc because this isn't recalcing at a regular interval.

I suppose, but it's far-fetched, that this xlam has a hook into the vba interface where it detects changes in the users own code and does the recalc.
It's just very strange...not to mention time consuming because it's at least 60 seconds if not more, and Excel in its entirety is locked, I can't even go to another open workbook while this ones calculating.

Thanks for any more help or thoughts,
--Jim