Save alert in Excel will not prompt anymore

Asked By 10 points N/A Posted on -
qa-featured

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. 

SHARE
Best Answer by Michelle Bang
Answered By 0 points N/A #102320

Save alert in Excel will not prompt anymore

qa-featured

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

 

Best Answer
Best Answer
Answered By 0 points N/A #102321

Save alert in Excel will not prompt anymore

qa-featured

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

Answered By 10 points N/A #102322

Save alert in Excel will not prompt anymore

qa-featured

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

Login/Register to Answer

Related Questions