title: What's the lifetime of Application.ScreenUpdating value in Excel 2010?
body: <p>As far as I know Application.ScreenUpdating = true value is maintained until Application.ScreenUpdating = false is set. But what's the 'lifetime' of this value? Is it while the procedure where it's called starts and finish, while Worksheet is opened, or?</p>
  <p>Made a class to keep ScreenUpdating value consistent to my needs:</p>
  <ul>
  <li>Init class</li>
  <li>set ScreenUpdating = False</li>
  <li>At the end of procedure or in case of error restore the value to True.</li>
  </ul>
  <p>The class handles this case ok.</p>
  <p>Some times need the opposite:</p>
  <ul>
  <li><p>Init class</p>
  </li>
  <li><p>set ScreenUpdating = True</p>
  </li>
  <li><p>At the end of procedure or in case of error restore the value to False.</p>
  <p>I'm having trouble here; the class sets properly the value ScreenUpdating = false, but when the class gets the 'actual' value of ScreenUpdating it is always true. There are no other procedures or addins that could be changing the value.</p>
  </li>
  </ul>
  <p>Have prepared a <a href="https://www.dropbox.com/s/fch92jtaeactc6d/ApplicationScreenUpdate.xlsm" rel="nofollow noreferrer">test sheet</a> to show the points above. Select the value for ScreenUpdating from the dropdown above the &quot;suCaller&quot; button.</p>
  <ul>
  <li>Select False and press the button.</li>
  <li>Value before setting False is True as expected.</li>
  <li>Test data is filled from another procedure showing ScreenUpdating new value (False).</li>
  <li>After data fill, the value is reset to True.</li>
  <li>Press the button again and <strong>'Actual' value is True as expected</strong>.</li>
  <li>Do it many times and values should be fine.</li>
  </ul>
  <p>Now Select True and press the button.</p>
  <ul>
  <li>Value before setting True is True as expected (which is the value from above)</li>
  <li>Test data is filled again showing ScreenUpdating new value (True)</li>
  <li>After data fill, the value is reset to False.</li>
  <li>Press the button again and <strong>'Actual' value is True not False</strong>.</li>
  </ul>
  <p>The class just negate the new value to define the restore value, so the result confuses me on the lifetime or how ScreenUpdating value should be set.</p>
  <p>Am I doing something wrong in the class or missing some basic theory?</p>
  <p>Class Module: ApplicationScreenUpdate</p>
  <p>Test Module: Test</p>
  <p><a href="https://www.dropbox.com/s/fch92jtaeactc6d/ApplicationScreenUpdate.xlsm" rel="nofollow noreferrer">Test Sheet</a>
  TIA, Oscar.</p>