I have a book
In this link you have a functional example that can be used as a reference:
It must be adapted so that the progress of the load bar is related to the remaining time of execution of your macro. For that you would need more info about your macro.