Private Sub Workbook_Open() and links

[vanhunk]

I have looked at many posts relating to this and could not get any clarity, please help:


I want to open a workbook manually, not from another workbook.
When I open the workbook I do no want the question whether to update links displayed.
After I worked with the workbook I want to update the links to data in another workbook. This will be done by activating a macro with a button on one of the sheets. Only than must the links be updated.

I am not sure how to do this, could you please give some guidance?

Also see the comments below.


Private Sub Workbook_Open()

'Does the following line merely "switch off" the question, or does it prevent auto updating links
'as well?
Application.AskToUpdateLinks = False

'Not sure if the next line is necessary and exactly what it causes. I.e. can I still update links?
ThisWorkbook.UpdateLinks = xlUpdateLinksNever
End Sub

[vanhunk]

Private Sub Workbook_Open()
   
  'Does the following line merely "switch off" the question, or does it prevent auto updating links
  'as well?
  Application.AskToUpdateLinks = False
   
  'Not sure if the next line is necessary and exactly what it causes. I.e. can I still update links?
  ThisWorkbook.UpdateLinks = xlUpdateLinksNever
  End Sub