title: How to disable save and protected sheet prompt in excel using VBA
body: <p>I have an excel sheet which is protected, since the sheet is protected I don't want the user to save it, and I don't want the <code>save the sheet prompt</code> to appear when someone closes the workbook. Till now I have been using this:</p>
  
  <pre><code>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
      Cancel = True
      Application.DisplayAlerts = False
  End Sub
  </code></pre>
  
  <p>Using this code, save feature is disabled but the prompt is still appearing </p>
  
  <p><strong>Similar problem:</strong><br> Since the workbook is protected whenever someone tries to change the cell content it displays  an alert, I want to disable that prompt message as well.
  Can someone help me to fix this</p>