title: vba before save event change cell value?
body: <p>I am trying to set the value of my cell R3 to 'RDC Mode' when the user hits save.</p>
  
  <p>The value which has changed needs to be saved as the workbook is saving.</p>
  
  <p>For some reason this code won't change my value.</p>
  
  <pre><code>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
  Worksheets("Place Orders").Range("R3").Value = "RDC Mode"
  End Sub
  </code></pre>
  
  <p>Please can someone show me where i am going wrong?</p>