File closes without prompt to save!!!
 

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

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

File closes without prompt to save!!!
 

Also check the WorkBook_Before_Close procedure for any code.


"corey" wrote in message
...
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

File closes without prompt to save!!!
 

D/COREY
Thanks for the sugestion. The workbook which is kept open always uses some
procedures wherein I have used display alerts to false. I will go there and
before the procedure ends will add display alerts=true. Thank you very much.
brgds/captgnvr
"corey" wrote:

Also check the WorkBook_Before_Close procedure for any code.


"corey" wrote in message
...
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