Application screenupdating false not working excel 2016
For my personal knowledge, i'm not familiar with this reference to your sheets : @ Louis H, The OP is referring to the sheet code not the sheet name. Reading your code, i don't see why you are using the select command as you don't do anything with your selection. Select" and run the macro but if your Screen Updating is set to false it shouldn't solve your problem. Screen Updating incorporated but the screen still flashes/flickers when the code runs - everything (charts/tables etc.) momentarily disappear and re-appear when it runs so it doesn't look very slick. Private Sub Combo Box7_Change() On Error Go To err Handle: Application. When the selection in Combo Box7 changes, Macro41 changes cells values in Sheet17, a Text Box (Active X Control) located below Combo Box7 in Sheet8 reads from the new cell value in Sheet17. The page has a couple of charts reading from other sheets, some tables with formulas, text boxes reading from other sheets and some combo boxes being used as dropdowns. This means that the Excel screen can look like it has "gone crazy" while the macro is running.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. I tried to modify your code to remove any Select/Activate command in my opinion you don't need to unprotect the Sheet8 for the Text Box to update.
Press , then click the "No" button in the "The following features cannot be saved in macro-free workbook" warning dialog. Choose "Excel macro-enabled workbook" from the "Save as type" drop-down list and click the Save button. Paste Special Paste:=xl Paste Values, Operation:=xl None, Skip Blanks _ :=False, Transpose:=False Application. Replace What:="zz", Replacement:="", Look At:=xl Part, _ Search Order:=xl By Rows, Match Case:=False, Search Format:=False, _ Replace Format:=False Range("AH6: AI" & lrow).