Hi Brian,

Set wbBook = Workbooks.Open( MyFile, False, False)

The second argument (UpdateLinks) of the Open method is not persistent.

If the file is subsequently opened, the links alert will appear.

I want to have the alert appear again when I open the workbook manually.

In that case, no additional action is required.

---
Regards,
Norman



"Brian Delaney" wrote in message
...
Hi,

Can anyone please give me a hand with this beginner question?

I'm opening a workbook in a procedure and disabling the alert asking if I
want to update links to other workbooks:

Set wbBook = Workbooks.Open( MyFile, False, False)

But then when I close the workbook at the end of the same procedure, I
want to reactivate the alert. Else, when I open the workbook manually in
Excel, a dialog box opens looking for the linked files for updating and I
have to hit Cancel a few times to close the box. I want to have the alert
appear again when I open the workbook manually.

Thanks in advance,

Brian