title: Why am I still getting a save prompt?
body: <p>When I close my excel file, I ask the user to take a survey if they have Microsoft Outlook installed. The program works great and I receive the email with the survey results. However, they are still prompted with the "Do you want to save this document?" I have used my previous code to stop this prompt from coming up and it is...</p>
  
  <pre><code>Me.Saved = True
  </code></pre>
  
  <p>This has worked prior to this. However, the saving prompt still comes up. I am wondering why this is happening.</p>
  
  <p>Here is my entire code from the BeforeClose Worksheet declaration. I have also used ActiveWorkbook.Saved = True, ThisWorkbook.Saved = True; however, the prompt still comes up...</p>
  
  <p>UserForm2.Show goes to my userform that prompts the survey.</p>
  
  <pre><code>Private Sub Workbook_BeforeClose(Cancel As Boolean)
  UserForm2.Show
  Me.Saved = True
  End Sub
  </code></pre>