6diegodiego9
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 80
- Office Version
- 2016
- Platform
- Windows
Problem demostration: create a new sheet, draw a big blue rectangle and write random data in A1, A2 and A3. Then set an autofilter on A1 and try to use the filter.
(Unless you've a very fast PC) you will see that the big blue rectangle flickers (fastly disappear and reappear) every time you change the filter.
I've a complex file with many graphic elements and macroes where this problem is very visible at every little action and therefore very annoying.
Is there a way to avoid it atleast inside macroes?
(I tried to put the autofilter line (causing the flicker) between Application.ScreenUpdating = 0 and Application.ScreenUpdating = 1 but the problems is still there)
(Unless you've a very fast PC) you will see that the big blue rectangle flickers (fastly disappear and reappear) every time you change the filter.
I've a complex file with many graphic elements and macroes where this problem is very visible at every little action and therefore very annoying.
Is there a way to avoid it atleast inside macroes?
(I tried to put the autofilter line (causing the flicker) between Application.ScreenUpdating = 0 and Application.ScreenUpdating = 1 but the problems is still there)
