View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
corey corey is offline
external usenet poster
 
Posts: 11
Default File closes without prompt to save!!!

Ensure ALL MAcro's have this at the end just before End Sub

Application.displayalerts=true


"CAPTGNVR" wrote in message
...
Dear All
Sometimes excel file closes without prompting to save even though some
changes were made to the sheet. - excel97. I have another excel file
open
during those times.

Pls can anyone tell me what could be the reason?

brgds/captgnvr