![]() |
Pictures on worksheet flickering as they are repainted
I have a worksheet that gets populated with up to 60 little pictures.
My macro uses the Application.screenupdating=false and true to help with flicker and speed when it is putting them on the sheet. My question is with just plain scrolling up and down the worksheet, using the mouse or what ever, the pictures all get repainted and flicker. It is quite an annoyance. Is there some way to reduce/eliminate this screen repaint when just moving around on a worksheet? Thanks Scott |
Pictures on worksheet flickering as they are repainted
It's probably a function of your video card that can't keep up. Try
the running the macro on a couple of other machines with different hardware and see if there's a difference. SteveM On Nov 15, 3:01 pm, Riddler wrote: I have a worksheet that gets populated with up to 60 little pictures. My macro uses the Application.screenupdating=false and true to help with flicker and speed when it is putting them on the sheet. My question is with just plain scrolling up and down the worksheet, using the mouse or what ever, the pictures all get repainted and flicker. It is quite an annoyance. Is there some way to reduce/eliminate this screen repaint when just moving around on a worksheet? Thanks Scott |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com