Dear All,
Currently I am using VBA Code below to Stop Update links prompts
[[VBA]Private Sub Workbook_Open()
Workbooks.Open "C:\Temp\Book2.xls", UpdateLinks:=False
End Sub[/VBA]
Is there code I can use such This Workbook so that I can save this file as another name and it will work?
Biz[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Dear All,
I have found VBA code that works.
[VBA]
Private Sub Workbook_Open()
Workbooks.Open ThisWorkbook.Name, UpdateLinks:=False
End Sub
[/VBA]
Biz