The VBA IDE will discard changes without warning
Actually that should be...
Workbook_BeforeClose not ThisWorkbook.BeforeClose
Jim Cone
"Jim Cone"
wrote in message ...
You could have code, someplace, that tells Excel not to save the workbook...
ThisWorkbook.Saved = True
or maybe something in the ThisWorkbook.BeforeClose event that does the same thing.
--
Jim Cone
Portland, Oregon USA
|