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

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