+ Reply to Thread
Results 1 to 5 of 5

Suppressing msgboxes appearing during loop

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    Suppressing msgboxes appearing during loop

    Hi

    Basically upon opening my workbook, I have some code that runs to loop through all the sheets and make certain sheets visible based upon which password the user enters. However, I also have some code upon activation of some of these sheets to have a msgbox pop up explaining what the sheet is about. I obviously dont want these to appear when the initial loops is going through activating the sheets one by one - I only want these msgboxes to appear when the user subsequently opens one of these sheets. Any ideas?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Suppressing msgboxes appearing during loop

    Hello msixdatateam,

    Welcome to the Forum!

    There is quite a bit going on here. Posting your workbook will get your questions answered quickly and accurately.

    How To Post Your Workbook
    1. At the bottom right of the Reply window, Click the button Go Advanced
    2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
    3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
    4. Click the Select Files button at the bottom middle of the dialog.
    5. In the new window Find the file you want to upload, select it, and Click Open.
    6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
    7. Wait until the file has completely uploaded before you exit the File Manager dialog.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Suppressing msgboxes appearing during loop

    You may try:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  4. #4
    Registered User
    Join Date
    11-14-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Suppressing msgboxes appearing during loop

    Thanks! This is exactly what I needed.

  5. #5
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Suppressing msgboxes appearing during loop

    You are welcome.

    Please remember to select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 03-13-2011, 06:37 PM
  2. Need to suppress MsgBoxes
    By bconner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2009, 02:12 PM
  3. [SOLVED] Suppressing a message box
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2005, 11:35 AM
  4. Suppressing the Web toolbar
    By vanzimmer in forum Excel General
    Replies: 0
    Last Post: 02-24-2005, 02:20 AM
  5. [SOLVED] Suppressing events
    By rci in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2005, 04:06 PM

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