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

Reset alerts when closing workbook?
 

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

Reset alerts when closing workbook?
 

Thanks for the confirmation, Norman. I thought that should be the case:
that alerts would reappear -- but they still don't. Think this could
possibly have anything to do with my first having tried

Application.DisplayAlerts = True/False

lines?

Brian

*** Sent via Developersdex http://www.developersdex.com ***

Reset alerts when closing workbook?
 

Hi Brian,

provided that your macro restores the setting, i.e:

Application.DisplayAlerts = True

after any


Application.DisplayAlerts = False

You should not experience any problem in this regard.

If you still have a problem, post the complete procedure code.

---
Regards,
Norman



"Brian Delaney" wrote in message
...
Thanks for the confirmation, Norman. I thought that should be the case:
that alerts would reappear -- but they still don't. Think this could
possibly have anything to do with my first having tried

Application.DisplayAlerts = True/False

lines?

Brian

*** Sent via Developersdex http://www.developersdex.com ***