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.