title: VBA to ask user if he wants to save the workbook?
body: <p>I want users to get the option to save their workbook (if they have made any changes) at the beginning of my macro. How can I achieve this?</p>
  
  <p>I've tried:</p>
  
  <pre><code>ThisWorkbook.Save
  </code></pre>
  
  <p>but unfortunately it doesn't generate any prompt.</p>
  
  <p>I've also tried:</p>
  
  <pre><code>ThisWorkbook.Save(ThisWorkbook.FullName)
  </code></pre>
  
  <p>but it asks users if they are sure that they want to overwrite the existing file - so it gives a different prompt than the one I want.</p>