flickering

  1. J

    Simplify my macro trigger so my table stops flickering?

    Hi All, I'm looking to simplify my macro which is triggered when a value within a drop down changes. The macro then finds all rows within a table that do not contain that value that matches the drop down and calls a macro to hide rows that do not match. As this process contains a few steps in...
  2. D

    Searching in Excel crashing/Flickers

    Hello, this has been an on-going issue but now it's getting out of hand. My excel crashes, I can't close it from the taskbar nor can I CTRL, ALT & DEL, so have to power down. Usually I've got 6-7 spreadsheets open working on a 3 screen setup. Since last night, I tried a few different ways...
  3. K

    Running macros in Excel 2016 - screen flickering

    I've been running the same macros for years now, and it's been working perfectly in both Excel 2007 and 2010. But now my job's updated to 2016, and when I try to run the same macro the screen is flickering. When speed isn't a issue, I prefer to have "screenupdating = true", so that I can see...
  4. W

    Application.ScreenUpdating=false not working when secondary sub is called

    Hi, I got an annoying issue with Application.ScreenUpdating. It worked fine until I added a secondary subroutine into the code. I tried to look for a solution and already attempted to fix the issue by calling the following subs at the beginning and at the end of the primary and secondary subs as...
  5. C

    VBA: Label Update = Flicker

    Hello all, I have a bit of a problem and hope you can help me. First of all, I'm not that much of an VBA expert, so please bear with me and use simple explanations. ;) I have a userform with a picture in the backround. On that picture are many labels with numbers as caption as well as spin...
  6. DaLook

    Workbook flashes

    I have an end user who s excel files constantly flash. I managed to fix some by unchecking "Show Page Breaks" but it does not work for all files. I also have tested these files on other PCs with no issues. Old file new created files all flash. Anyone have some other suggestions that I could try...
  7. ClimoC

    Query Tables and Screen Flickers

    Ahoy No, this is not about ScreenUpdating = True/False Neither is it because you've turned SU off, and then used 'Select' or 'DoEvents' etc in your code. When running an update for a QueryTable (once a second), 3 'buttons' (activeX image controls with code behind them) flicker - though I see...
  8. R

    Stopped the flicker then added a protect/unprotect to the macro and flicker started up again??

    Hi there, I have the code below that hides rows if the test cell is 0 or blank. The screen on sheet 1, which drives the results for this "Q U O T E" Sheet, was flickering badly when every drop down box or tick box was selected. I Fixed that with "Application.ScreenUpdating = False" However...
  9. VAndre

    slow refresh times in excel 2007 for workbooks with user-defined functions

    I have a couple of workbooks that use VBA functions. They have worked well in Excel2003 environments, but refresh time is very slow once I migrated to Excel2007. The speed is so slow that there is a visible series of blinks every time I refresh. It's really bad (I literally got a migraine the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top