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