File closes without prompt to save!!!

C

CAPTGNVR

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
 
C

corey

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

Application.displayalerts=true
 
C

CAPTGNVR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top