FWIW, this is what I get:

Workbook_Open: Error Auto Calc: True
Workbook_BeforeSave: Error Auto Calc: False
Workbook_BeforeClose: Error Auto Calc: False
My Excel 2002 appaerntly is too old to have "Workbook_AfterSave"

You prompted me to try something I don't usually do. If, when I'm ready to quit, I select auto-calc from the toolbar, then save (then check again to ensure it's in auto), then close the WB, it stays in auto mode on reopening. However, if I click the close button, then save when prompted, it has flipped itself over to manual on reopen. Never saw this before, MS programs always seemed to save the same on my 'puter regardless of the save method...

Russ