File closes without prompt to save!!!

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
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
 
Ensure ALL MAcro's have this at the end just before End Sub

Application.displayalerts=true
 
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

file size too big 4
How to zip an active workbook 4
Copied sheet not to have links 2
Source info deleted but chart still shows 3
BEST suggestion to keep formats? 10
disable from deleting rows; folders not to delete; sheets to inser 1
Close all without saving and exit without prompts 8
excel 97, VB project unable to view in another comp 2

Back
Top