View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DDMcH DDMcH is offline
external usenet poster
 
Posts: 1
Default automation difficulty

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?