no prompt for saving after making changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel (2003 on XP o/s) is not prompting to save changes to a workbook that
changes were made to. I can create a new workbook, type a few letters into a
cell then close it witout it asking to save the changes.

Dan
 
hi,
Sounds to me like display alerts has been turned off. not sure....wild guess.
try running this macro....

Sub macDAT()
Application.DisplayAlerts = True
End Sub

if that don't fix it, i'm stumped too.
Regards
FSt1
 

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

Excel prompts to save when no changes made 2
Referencing the file type 4
Read only prompt? 2
xls:1 but no xls:2 1
Save Changes Prompt at close 2
Personal Macro 1
Date modified changes when file not saved 5
Excel Save Changes Prompt 1

Back
Top