No Save Prompt dialog box when existing (V2003)

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi ya, I'm using Excel 2003 and recently have noticed that I do not get the
Save prompt dialog box each time I close the spreadsheet after doing some
editing.

I just tested it again by opening a blank spreadsheet, entered random data,
saved it and closed it. I then reopened the file, entered some random data
and when I click on Close I do not get the prompt to save.

I've checked in Tools, Options and looked around the usual tabs but no luck
and compared what I have selected with my colleagues


Can anyone help.
 
Mike,

Are you familiar with VBA and using the VBE.

If so, open the VBE, display the Immediate window, enter the following line
of code and hit enter:

msgbox application.DisplayAlerts

If a message box pops up that says "FALSE" then enter the following line and
hit enter.

application.DisplayAlerts = True

If the message box said "TRUE", then I don't know what else it could
be.........sorry!

HTH,

Conan
 

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

Prompt to Save Message 2
loss of redo function after installing auto-save 1
after installing auto-save, lost redo function but kept undo 1
Shared/Read Only WITHOUT Save prompt 3
installed autosave function and now have issue with redo function 2
save prompt for user exit, but no save prompt for batch import? 1
Dialog box when closing an unsaved spreadsheet 1
No longer prompted to Save 2

Back
Top