I got a master sheet linked to other sheets,
everytime the file is being open the dialog is comming "would you like to update the links yes/no "
I don´t want this dialog to pop up.
The linking should just update automatically.
I tried with this macro, but did not work, what did I do wrong ?
Sub Workbook_Open()
Application.AskToUpdateLinks = False
End Sub
I know I can just turn off this dialog under:
->tools -> options -> edit -> tickbox (ask to update links)
but since I am sitting on diferent workstations it would be easier if the macro would solve this.
Thanks a lot in advance for you help.
best regards
usl
everytime the file is being open the dialog is comming "would you like to update the links yes/no "
I don´t want this dialog to pop up.
The linking should just update automatically.
I tried with this macro, but did not work, what did I do wrong ?
Sub Workbook_Open()
Application.AskToUpdateLinks = False
End Sub
I know I can just turn off this dialog under:
->tools -> options -> edit -> tickbox (ask to update links)
but since I am sitting on diferent workstations it would be easier if the macro would solve this.
Thanks a lot in advance for you help.
best regards
usl