Display one sheet or two userforms while code is vba code is runningon another

[RJQMAN]

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.

 

[joel]

The best approach is not to use Select or Activate in your code so yo
don't get the page swapping. The worksheet will remain on the shee
that is selected when the macro is started. Also you wuold be able t
manually switch pages while the macro is running and watch the progres
of the macro without causing errors in the macro. the best practice i
not to use ActiveSheet or Active cell in you macro instead directl
refer to the cells

 

[RJQMAN]

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/showthread.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.