+ Reply to Thread
Results 1 to 3 of 3

dialog box suppress

Hybrid View

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    dialog box suppress

    Hello Experts,

    i am facing the issue with opening the workbooks via VBA.
    i try to open workbook usual way "workbooks.Open filename", but macro stuck at this step due to waiting for user action as dialog box pop up in new opened workbook.
    To be more specific, the new opened workbook loads a plenty of add-ins, and this dialog box is coming from them.
    I tried application.displayalerts = false but it does not solve the issue.
    Is there any way how to open workbook with disabling all add-ins, or suppressing all dialog boxes etc.? Or is possible to make actions on closed external workbook. In my case i need to perform "replace" function for all the sheets on external workbook.

    Thank you
    Jan

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,487

    Re: dialog box suppress

    Can you remove the add-in?

  3. #3
    Registered User
    Join Date
    07-26-2012
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    25

    Re: dialog box suppress

    I can only manually in trust center disable all application add-ins, but i cannot uncheck the COM addins, as this requires the admin rights.
    But i am afraid this would no solve my issue, as while executing the code, the macro stuck on workbooks.open line waiting for user action.

+ 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. [SOLVED] How do I suppress user dialog in File Save As?
    By Tony Lin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2006, 04:00 AM
  2. how to suppress office assistance dialog
    By Ormy in forum Excel General
    Replies: 0
    Last Post: 01-20-2006, 05:55 AM
  3. Suppress "Disable/Enable Macros" and Query Refresh dialog on open
    By Sharon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2006, 05:25 PM
  4. Replies: 0
    Last Post: 10-21-2005, 11:05 AM
  5. Suppress Save Dialog Box
    By r wilcox in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2005, 03:05 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