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
|