<div>
You can add below code in your Workbook module:<br />

<pre><code id="code-20-42008242-1">Private Sub Workbook_BeforeClose(Cancel As Boolean) 
    Dim answer As String 
    Dim question As String 
    question = &quot;have you completed all the fields in the workbook&quot; 
    answer = MsgBox(question, vbYesNo) 
     
    If answer = vbNo Then 
        MsgBox &quot;complete everything and then close&quot; 
        Cancel = True 
        Exit Sub 
    Else 
        ThisWorkbook.Save 
    End If 
End Sub </code></pre>
</div>


You can add below code in your Workbook module:


Private Sub Workbook_BeforeClose(Cancel As Boolean) 
    Dim answer As String 
    Dim question As String 
    question = "have you completed all the fields in the workbook" 
    answer = MsgBox(question, vbYesNo) 
     
    If answer = vbNo Then 
        MsgBox "complete everything and then close" 
        Cancel = True 
        Exit Sub 
    Else 
        ThisWorkbook.Save 
    End If 
End Sub 

<div>
Like below image;<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/02_w07/1144643/Workbook_Close_Prompt.JPG" target="_blank" title="Workbook Close Prompt (87 KB)"><img alt="Workbook Close Prompt" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/02_w07/800_1144643/Workbook_Close_Prompt.JPG" /></a>
</div>


Like below image;
Workbook Close Prompthttps://filedb.experts-exchange.com/incoming/2017/02_w07/1144643/Workbook_Close_Prompt.JPG

Workbook_Close_Prompt.JPG

<div>
If you made changes to the file then it should always ask if you want to save on exit. &nbsp;Are there any macros in the file that could be causing a problem?<br />
<br />
<b><i>~bp</i></b>
</div>


If you made changes to the file then it should always ask if you want to save on exit.  Are there any macros in the file that could be causing a problem?

~bp

Workbook_Close_Prompt-2.JPG

<div>
Pleasure Sir! Glad I was able to help
</div>


<div>
<div class="content wysiwyg-content">
Hi Guys, I update an Excel file everyday but for some reason it does not ask whether I need to save when I am exiting the spreadsheet and I lose my data as a result sometimes. Is there an Excel setting I can change to remind me to do this?
</div>
</div>


Hi Guys, I update an Excel file everyday but for some reason it does not ask whether I need to save when I am exiting the spreadsheet and I lose my data as a result sometimes. Is there an Excel setting I can change to remind me to do this?

Excel file that does not ask to be saved before exiting

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.