running a macro with only showing a progressbar

Problem with Excel 97

I use MS Excel 97 to perform an import of a textfile and remodel the file into a working excel-sheet in which our employees can calculate the estimates of revenue for next year and then export that data to a textfile again so it can be imported in our financial program. When you open the workbook and click on a button a textfile is opened and a number of macros are run in order to remodel the textfile.

Now I would like to add a procedure, which would show a progressbar when the macros are run and not all those shifting screens flashing by. I found the command APPLICATION.SCREENUPDATING = FALSE ,but how can I make it so that you see a progressbar when the macros are run?

Can anybody help me?

Rob Moone

I’m using a Pentium PC with Windows 95, 96 Mb RAM and Excel 97.