I have vba code in Access and Excel, and I have to pass control back and forth a couple of times (and out to notepad once).  I have stopped screen updates in Excel (w/ application.screenupdating) and in Access with docmd.echo false, yet there's still a lot of updates happening.  Does anyone know some code to stop all Windows screen updates while I'm passing data back & forth?

Thanks.

Try setting the .visible property to false while you do your updates and back to true when finished.


Steve