Say no to updates when opening workbook

[Blunder1]

Hi,

What would be the code be to add to a workbook so when it's opened it says no to updates?

Thanks

Blunder

 

[VoG]

Try like this

Workbooks.Open Filename:="test.xls", UpdateLinks:=False

 

[Blunder1]

Thanks, but i need it in the actual workbook. Ie when i open test.xls it automatically will say no to updates. The problem i have is the workbook name will change from day to day, so i cant use the saved name.

Thanks

Blunder

 

[VoG]

Maybe this in the ThisWorkbook module

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

 

[Blunder1]

Perfect, thank you VoG.

Apologies for the delay in replying, i only checked it this morning!

Blunder