Assuming you are doing that to force an update of the progress bar:

after each update of the progress bar, add

Userform1.Repaint
DoEvents

change useform1 to reflect the name of your userform.

There should be no requirement to close and open it.

--
Regards,
Tom Ogilvy


"DDMcH" wrote in message
oups.com...
I have incorporated into a suite of macros a variation of the
"Displaying a Progress Indicator" developer tip that I found on
j-walk's web site. I have adjusted for the following wrinkle: the
process I wish to show progress for is not a repetitive action and is
not in a loop, but rather is 12 sequential steps. I have gotten
everything to work properly except for the automated aspect. My
problem is that I must click on the close button on the upper right of
the progress indicator dialog box for each successive step to be
performed and the progress indicator to be advanced. This would be
tolerable when processing single items at a time, but not when
processing a lengthy list of 160 items at 12 steps each. What am I not
doing correctly to allow this to be a single button push operation?