Reset alerts when closing workbook?
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
|