View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Delaney Brian Delaney is offline
external usenet poster
 
Posts: 14
Default 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