Mike, We've already done this one today. Check out that thread in Google at
http://tinyurl.com/2hvgz

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Squid" wrote in message
news:jSTVb.266570$na.420570@attbi_s04...
I created an Excel application that has a lot stuff going in the
Workbook_Open Event. I would like to add a Form with progress bar to show
the user how much load time remains, but mainly to prevent them from
"touching" the workbook while the Open Event code is running. I viewed
Chip
Pearson's website for progress bars
(http://www.cpearson.com/excel/Progress.htm) and
http://j-walk.com/ss/excel/files/developer.htm for this. I understand the
basic workings of these samples. But I dont quite understand how to code
the progress bar for my items (how to compute total time, then increment).
Could someone explain this further?

Thanks!
Mike