See John Walkenbach's page on this for detailed instructions:

http://j-walk.com/ss/excel/tips/tip34.htm
Progress Bar

--
Regards,
Tom Ogilvy


"Malcolm" wrote in message
...
Hi

I have a spreadsheet that contains a lot of information about client
personal, loan & account details.

I have created a macro that turns all this information into individual
statements for each client in a new worksheet.

What I would like to do if possible, is to have a progress bar that shows
how much is done and is left to do as the process is being carried out.
Currently, a new worksheet openms but, apart from the hour glass, it does
not look like anything is happening and may cause another user to try and
stop or restart the process.

Any help wopuld be greatly appreciated.

By the way, all the work done creating the macro was done with lots of
help from people on these Excel communities as I am not a programmer in any
shape or form, so with this in mind, please give as much information as you
possibly can if the problem can be solved.

Many thanks

Malcolm