title: Can't make Application.DisplayAlerts = False in Excel 2016 VBA
body: <p>I have been chasing my tail for weeks, with more hours "Googling around than I want to admit. </p>
  
  <p>I have a large, complex analytical app within an Excel 2016 spreadsheet that captures SQL table data, queries email data and does a lot of stuff that I think is pretty cool.  Users see sales force automation performance metrics and charts.  All is well except for one thing.  I cannot stop the "save data?" dialog box from appearing no matter what I do.  </p>
  
  <p>As a workaround I've put the spreadsheet on on a network ride and given users a shortcut that runs a VBscript to copy this spreadsheet to a hidden drive on the local PC and runs it.  So if they save it, there's no worries as they aren't working with the original data.  But as one would easily imagine, the load time is necessarily longer than it need be and users are confused by a message when I am telling them they can't save the data.</p>
  
  <p>Net of a lot of different experiments, it seems like I've uncovered a bug in Excel (yeah, I know, this sounds lame even to me) as I cannot make the Application.DisplayAlerts = False.  It just will not take.</p>
  
  <p>See image here:
  <a href="http://i.stack.imgur.com/LFx68.png" rel="nofollow">enter image description here</a></p>
  
  <p>The image above (or at the above link as I haven't submitted enough question yet to embed images) is obviously taken from the Immediate Window when I was running the app.  I entered the steps in the exact order shown. Note that I set Application.DisplayAlerts = False and then checked the value immediately afterwords and it was True.</p>
  
  <p>Very weird.  Is this a bug?</p>
  
  <p>One last aside that is probably irrelevant; I was using .XLSB format because of the smaller footprint, much shorter load time and to get around PC setup issues with macros.  But I've switched back to .XLSX to simplify the experiment.</p>