PDA

View Full Version : Solved: Save before closing workbook. Close workbook, recalculates cells & prompt to save?



malik641
10-13-2005, 03:01 PM
In my workbook_open event I've turned off the Recalculate cells before save, and that works. I'll press save and it saves without recalculating cells.
But when I press the X to close the workbook, it will recalculate the cells and then ask me if I want to save :dunno

I have a Workbook_BeforeClose event that changes some of the application settings back to what they were. Is this why this is happening?

How can I rid of this?

TIA :thumb

Zack Barresse
10-13-2005, 03:12 PM
Trap your saves using the BeforeSave event, then code your close events to save as you desire.

malik641
10-13-2005, 04:05 PM
Gotcha :thumb ...Forgot about that.

Thanks Zack, markin' it solved :yes


I guess when you stare at code for so long (8-10 hours), you zone out pretty bad and can't think straight :bug: