Stop dialog box popping up

[arrun]

Dear all, I have an excel file which has a link to a word. Whenever I open this excel file, at the point of opening, a dialog box pops-up saying, "this workbook contains links to other data sources.......update? dont update? help" I would like to stop this dialog box popping up. Is there any VBA code which can be placed with the workbook_open event to stop that?

Thanks,

[Simon Lloyd]

What do you want to do with the links? always update, never update or ask to update?

[arrun]

I want "never update"

[Simon Lloyd]

Add this to the ThisWorkbook code module:
[vba]Private Sub Workbook_Open()
Me.UpdateLinks = xlUpdateLinksNever
End Sub[/vba]

How to Save a Workbook Event Macro
1. Copy the macro above
2. Open your Workbook and press ALT+F11 keys to open the Visual Basic Editor.
3. Press CTRL+R keys to shift the focus to the Project Explorer Window
4. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
5. Press the Enter key to move the cursor to the Code Window
6. Paste the macro code using CTRL+V
7. Save the macro in your Workbook using CTRL+S

[arrun]

Thanks Simon for your reply. However your code was generating an error, so I changed it to:

Private Sub ThisWorkbook_Open()
Me.UpdateLinks = xlUpdateLinksNever
End Sub

However above code could not stop popping up that dialog box. I am using office-2010. Is there any better idea?

Thanks,

[mdmackillop]

Simon's code works for me in 2010. Check you have it in ThisWorkbook module.

[Simon Lloyd]

Thanks Simon for your reply. However your code was generating an error, so I changed it to:

Private Sub ThisWorkbook_Open()
Me.UpdateLinks = xlUpdateLinksNever
End Sub

However above code could not stop popping up that dialog box. I am using office-2010. Is there any better idea?

Thanks,

The code i supplied works for me in xl2003, xl2007 & xl2010, as MD said did you folllow my instructions on adding it to the ThisWorkbook code module?, just adding ThisWorkbook to OPEN won't make any difference to the problem it simply stops the code being workbook event code.