ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make macros run smoothly? (without the flickering) (https://www.excelbanter.com/excel-discussion-misc-queries/133862-how-do-i-make-macros-run-smoothly-without-flickering.html)

dominiej

How do I make macros run smoothly? (without the flickering)
 
any help please would help

Martin Fishlock

How do I make macros run smoothly? (without the flickering)
 
having less friction
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"dominiej" wrote:

any help please would help


Dave Peterson

How do I make macros run smoothly? (without the flickering)
 
....
application.screenupdating = false
your code that causes the screen to flicker
application.screenupdating = true
....

dominiej wrote:

any help please would help


--

Dave Peterson

Sunday88310

How do I make macros run smoothly? (without the flickering)
 
Contextures Excel Book List
http://www.contextures.on.ca/xlbooks.html
try "Professional Excel Development"
--
William<"M"
Using 2007


"dominiej" wrote:

any help please would help



All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com