I have created a macro that takes a long time to process. A lot of this time is because Excel is re-calculating.
I would like the user to know how much time has expired and (because I know how long the process takes on average to complete) how much time is left.
I would like to either include a progress bar or a timer or stop watch, but I don't think it would update during those times when Excel is re-calculating - which is most of the time.
Is it possible to overlay (if that's the right word) a progress bar or timer or stop watch on top of the spreadsheet that is in some way independent of Excel - i.e. it doesn't stop when Excel is calculating?
I hope that makes sense.
Many thanks
David