Mark Driscol has brought this to us :
I tried this at home, and it doesn't work in Excel 2007 there either.
I found a link to a posting that concludes the same thing, it doesn't
work in Excel 2007. Not sure how Garry got it work, but I appreciate
the response.

http://www.mrexcel.com/forum/showthread.php?p=1984500

As I stated, I pasted the code from the OP's J-Walk link into the
Main() sub of one of the CD samples that come with J-Walks book[s]. The
rest of the project was unchanged.

The Sub Main() code in the link appeared to be different than that of
the original CD samples and so I thought the OP's problem may have
resided there. When I first opened the XLA from the CD samples in
XL2007 I got the 'active content blocked' message below the Formula
Bar. After enabling the content I clicked the button on the spreadsheet
and it worked as did all the other samples in all the earlier versions
I tested in (v9 to v11)! I then replaced the code in Sub Main() with
the code found in the OP's link and clicked the button again. It
behaved exactly the same, displaying the progress bar and populating
the sheet with the data.

Not sure what you're doing (or not doing) that causes this to not work
for you. Note that I did not create the form as described in the link,
but used the existing form in the Progress1.xls example. Maybe the
problem lies there. That means the earlier version file works in XL2007
regardless of which Sub Main() code is used. So.., I opened a new
workbook in XL2007 and followed the instructions exactly as described
on the OP's link and ran Sub ShowDialog from the Macros dialog and it
worked same as before.

This begs me to ask the question "What exactly doesn't work for
you?"<g

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc