Screenupdating excel c courting vs dating bible
Other addins in Excel can interfere with that single global setting.
It is for that reason you are supposed to save the current Screen Updating state to a local variable before, and restore it after, each use. Xl Sheet Sheet Visible ' Hidden but user able to show Sheet. Xl Sheet Sheet Hidden ' Hidden for user as well Sheet.
It is a common result of other coders not following the above rule about restoring the previous state. I am experincing the same problem with Screen Updating (and other settings) being reset to true by the Bloomberg add-in with VSTO add-in. One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.Adding or removing a Worksheet or Workbook will also do this.The Excel version on each system is the same (14.0.6112.5000 (32-bit)). How can I fix it so that Excel respects my settings?