Results 1 to 2 of 2

Thread: Turn off

  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Turn off

    I have a module that opens a file, does some updates, then closes and saves changes. Some of the files have links to other workbooks.

    I want to turn off that annoying message about Update or Don't Update on open. My user is annoyed because he cannot leave for lunch with the process running. Has to be there to answer
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Turn off

    The Workbooks.Open method has an UpdateLinks argument. If you set this to 0, external links will not be updated and the user will not be prompted:

    Dim wbk As Workbook
    Set wbk = Workbooks.Open(FileName:="C:ExcelMyworkbook.xls", UpdateLinks:=0)
    ...

Posting Permissions

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