On Mon, 26 Apr 2010 11:56:12 -0700 (PDT), Wouter HM
wrote:

Hi Prof Wonmug,

Try This

Open Tools - Options
Goto tab Calculation
Select option Manual
Click OK


If you have the line of code below comment it out:
Application.Volatile

Use the F2 option as before

I've never used Application.Volatile. I'm volatile enough without
setting a special option. ;-)

The manual option seems to work. Is there any downside other than I
have to press F9 to see the results if I change anything? What won't
work that used to with option automatic?

I noticed that there is also an option manual except table. I'm not
sure exactly what that does, but it seems to make F2 work just like
with option manual, but if I change a constant that is used in a
table, the table gets updated.

Do you run with option manual always on or just when you need it?