XL:Surpressing dialog box


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: XL:Surpressing dialog box

  1. #1
    Martin Rydman Guest

    XL:Surpressing dialog box

    Hi all!

    I've got a workbook that may contain links to another workbook. As you all
    know, this will cause XL to ask the user if he/she wants to update values
    from that workbook when the first one is opened. In my setup, I never want
    to see this dialog. I've got VBA-code that will connect to the other
    workbook, and I never want XL to update with data from the other workbook.

    Any ideas?

    TIA
    /Martin



  2. #2
    mrfelis Guest

    Re: XL:Surpressing dialog box

    Martin,

    Two possibilities:

    Workbook.Open has a parameter that allows you to open a workbook without
    updating links.
    Application.DisplayAlerts=False will turn off these message boxes.

    Both are well documented in XL's Help.
    --
    ~~~
    C'Ya,
    mrfelis
    mrfelis@yahoo.NOSPAM.com
    just remove the spam
    Martin Rydman <martin.rydman@telia.com> wrote in message
    news:39af5cd8@news.devx.com...
    > Hi all!
    >
    > I've got a workbook that may contain links to another workbook. As you all
    > know, this will cause XL to ask the user if he/she wants to update values
    > from that workbook when the first one is opened. In my setup, I never want
    > to see this dialog. I've got VBA-code that will connect to the other
    > workbook, and I never want XL to update with data from the other workbook.
    >
    > Any ideas?
    >
    > TIA
    > /Martin
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center