View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default 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