problem with Application.ScreenUpdating
Betty,
I'm not exactly sure what you mean.
Application.ScreenUpdating = False stops the display from
changing while your macro is operating. This makes things
run quicker and prevents the user from seeing a whole lot
of annoying flickering stuff! However, once your macro has
run, the changes that were made (values altered, workbooks
created and so forth) will all be visible to the user
unless you have closed or hidden them.
Pete
-----Original Message-----
Hi,
Is the purpose of Application.ScreenUpdating = False in
an
Excel macro supposed to "hide" changes to the workbook
from the users? The worksheet that is being created by
my
macro displays and runs the commands so users can see
even
though I have Application.ScreenUpdating = False.
I don't want anything to display.
I am using Windows XP and MS Excel 2003. I have
installed
MS SP3 also.
Why doesn't the Application.ScreenUpdating = False work?
Thank you,
|