I have VBA code that freezes and unfreezes windows on a worksheet
while it searches for the best presentation. Although it only takes
10 seconds or less to execute, this is annoying to watch, and I do not
know how to prevent it from displaying.

If I use application.screen update = false then the windows do not
freeze or I get an error. The same thing happens if I minimize the
worksheet. The same with the events = false application.

Tthis sequence of events is occuring as a part of a larger sequence of
operations, the total taking about 1-2 minutes to run at the most
depending on processor speeds. While the sequences run, I am
displaying a userform with a progress bar. The progress bar is small
and centered on the screen.

I am considering either displaying a blank worksheet behind the
userform progress bar while the code runs, making changes on a
different worksheet, or perhaps if necessary, display a 2nd userform -
a large blank one - behind the userfform with the progress bar. Is
either of those options possible? I do not know. If I cannot find a
better solution, I could make the progress bar userform larger - is
that the most practical approach?

I appreciate any advice.

Thanks.

On Dec 28, 5:30*am, joel <joel.43w...@thecodecage.com> wrote:
> The best approach is not to use Select or Activate in your code so you
> don't get the page swapping. *The worksheet will remain on the sheet
> that is selected when the macro is started. *Also you wuold be able to
> manually switch pages while the macro is running and watch the progress
> of the macro without causing errors in the macro. *the best practice is
> not to use ActiveSheet or Active cell in you macro instead directly
> refer to the cells.
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: 229
> View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=165330
>
> Microsoft Office Help

Thank you for the advice. I had been using a lot of activate
statements. I will give it a try. I appreciate it.

Q.