View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default Unpleasant VBA Agility

Hi

Try putting

"application.screenupdating = false"

at the starts of macros for which you wish to hide the "agility" factor.

This command hides changes of sheets,data updating visually and a host of
others actions


You may turn on screenupdating gain with

"application.screenupdating = true"



Happy hunting


Regards N10



"Varne" wrote in message
...
Hi Chip

Thanks

If you click for action or report in an accounting package it comes to
your
screen with just one change. However underneath the dbms must be gathering
data or consolidating data from many tables. You do not see it.

Now VBA does it in front of you running to and from pages, fields and
cells.
Cannot this be hidden?

Varne M

"Chip Pearson" wrote:

Just what does "agile" mean in the context of VBA?


"Varne" wrote in message
...
Hi

My VBA applications are too agile. I am trying to sell a few VBA
applications on accounting but am afraid the said problem will be a
negative
factor. Cannot VBA made to perform below the surface with an inbuilt
macro
screening it?

Varne M