Hello
I have this workbook that when opens I asked it (in the Workbook_Open() subroutine) to do a lot of things in Sheet1, then a lot of things in Sheet2 as well, and finally a lot of things in Sheet3.
So, when I re-opened the workbook to see if the things that I asked it to do in all of those sheet work or not, it did successfully but annouyingly. I mean when I open the workbook I can see that it displays Sheet1 for me first and does all the things I asked it to do there and then switches to display Sheet2 and stays there for some time until it does all what's required and finally it goes to Sheet3 and wastes some time there while finishing up what it supposed to.
My question is: Is there a way that I can avoid such a switch-between-sheets behavoir? In other words: Can the workbook upon opening displays to the user something like (Loading... Please wait) message until it finishes from all the things it needs to do in all the three sheets, and then to let this loading message disappear when everything is ready for the user to use the workbook?
Bookmarks