title: Turning drop and drag capability back on before close of workbook
body: <p>I have a workbook that requires no drag and drop to occur. I turned off the drag and drop function on open of workbook by</p>
  
  <pre><code>Private sub Workbook_open()
  Application.CellDragAndDrop = False
  End Sub
  </code></pre>
  
  <p>I am trying to turn it back on before close with</p>
  
  <pre><code>Private sub Workbook_BeforeClose()
  Application.CellDragAndDrop = True
  End Sub
  </code></pre>
  
  <p>It is not working.</p>