Excel prompt clicker vba

[tech3]

Anyone know's any vba code that can automatically select answer from which an excel workbook prompts? Thank you xx

 

[mumps]

Please describe in much more detail, step by step, what you want to do. What do you mean by "an excel workbook prompts"?

 

[tech3]

Example workbook2 to vlookup to workbook1 now everytime i i open workbook 2 there is this excel prompt either i ishould update the link or not. Thanks for your help

 

[mumps]

In your macro that opens workbook 2, use a line of code similar to this:

Workbooks.Open "C:\Test\workbook 2.xlsx", UpdateLinks:=True