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

Similar Threads

Word OLE to check spelling in text box 1
file size too big 4
Save workbook without shapes 0
Excel keeps asking me if I want to save an already saved file. 0
#ref error 0
Copied sheet not to have links 2
SOS- getting 'program error' and excel closes. 0
Word 2013 DDE merge to Excel file 0

Top