no blinking when running and progress bar

Hi mqdias,

Have you tried

Please Login or Register  to view this content.

to stop any blinking? Don't forget to turn it back on at the bottom of your routine.
See
http://www.cpearson.com/excel/optimize.htm or
http://www.excelitems.com/2010/12/op...er-macros.html

Originally Posted by mqdias

Hi,

I have a little application in VBA that takes about 1 minute to be finished.
When running, the screen "blinks" because de application makes some changes between sheets wich generates that blink.

Is there any way that i can fix the current sheet where i have the command button and run the application without changes between sheets and also put some progress bar to be shown during the run so the user can see the progress?

Thanks!

I use this

Please Login or Register  to view this content.