PDA

View Full Version : Private Sub Workbook_Open() and links



vanhunk
08-17-2012, 12:18 AM
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
08-23-2012, 04:10 AM
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