+ Reply to Thread
Results 1 to 6 of 6

"Loading ... Please Wait" Message

  1. #1
    Registered User
    Join Date
    02-12-2006
    Posts
    54

    "Loading ... Please Wait" Message

    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?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    lets see the code, we can't tell you anything without it, you may be using a lot of selects and activates that are not required

  3. #3
    Registered User
    Join Date
    02-12-2006
    Posts
    54
    yes I am using a lot of selects and activations of the sheets, because this is the only solution for the selects to work. And the reason for it is found in one of my questions in this forum at

    http://excelforum.com/showthread.php?t=581427

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    At the very begining of your code, just add
    Please Login or Register  to view this content.
    and at the end of your routine, just add
    Please Login or Register  to view this content.
    In addition, your macros will run faster ...

    HTH
    Carim

  5. #5
    Registered User
    Join Date
    02-12-2006
    Posts
    54
    Thanks, but which code are you talking about spefically? The codes I have in Sheet1, Sheet2, Sheet3.. or my own functions and subs that I wrote for the whole workbook to work as I wanted to?

    I have a lot of codes, so which one do you mean?

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    You still haven't shown us the code...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1