Save alert in Excel will not prompt anymore

Asked By charles garcia 10 points N/A Posted on - 01/20/2012

I’ve been working on excel for a long time. I rely on the save alert when you attempt to close the program without saving it. Then it stopped asking me if I wanted to save my modified files when I close the program to shut off my laptop. I did not reconfigure my excel settings and I’m pretty sure I did not manually save the files I was working on. Where do I check the settings for this? Is it part of the Automatic Database recovery settings? I know it’s supposed to prompt me to save my files but I do not see that anymore. 

• Status: Open
• Question Views: 1476
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Michelle Bang

Go To Solution

Answered By Experttechyv 5 points N/A #102320

Save alert in Excel will not prompt anymore

There might some changes that you made in excel that are causing the save alert not to appear when you are saving your document, and to fix that you will need to edit the macro as follows:

• You will need to open a new workbook in excel and the press the ALT+F11 keys on the keyboard to open the visual basic editor.
• You will then need to copy the macro below in the code window of any sheet:
• Sub testLesson13a1()

    Application.Quit

End Sub

• After that save the changes and exit the visual basic editor.

You can now create a document and then try saving it and see if it will bring you the save alert message.

-Experttechyv

 

About Experttechyv

Questions
0

Answers
200

Best Answers
30

• Vote Up 0 Vote Down

• Posted on - 01/20/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Michelle Bang 55 points N/A #102321

Save alert in Excel will not prompt anymore

You can write this piece of code in order to solve the issue Application.DisplayAlerts = False 'your saving code Application.DisplayAlerts = True If you want NOT to save changes, use the first of the codes below. Me.Saved = True End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Save End Sub If you want to save changes use the code below Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Save End Sub One of these codes whoever you chose must be in the Private Module of the Workbook Object (ThisWorkbook). To get there from Excel, left click on the Excel icon located on top left next to File and choose "View Code". Paste the code. Sub No_Save() ThisWorkbook.Saved = True ''or 'ActiveWorkbook.Saved = True End Sub For more information go here and try different links

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 01/20/2012
• Question Category: MS Excel

Answered By charles garcia 10 points N/A #102322

Save alert in Excel will not prompt anymore

Got that. That was very so kind of you. This saving mode in excel really freaking me out. I was working on my files all over again. If only I knew it at first this won't happen.. So glad I have this site.. Thanks Michelle

About charles garcia

Questions
22

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/19/2012
• Question Category: MS Excel