Re: 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" <bpdelaney@xxxxxxx> wrote in message
news:NuCdnWFSm9rq1JreRVn-1w@xxxxxxxxxx
> 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
>


.

Relevant Pages

  • Pre Alerting Opening One Bids In The ACBL
    ... openers, and opens some large percentage of 10 counts which are 5-5s, ... and 7 card suits need to pre alert. ... One extreme could be that anything more aggressive than the Rule of 20, ...
    (rec.games.bridge)
  • Re: Kitty FC spoke!
    ... She opens her mouth but ... >no sound ever comes out. ... >Because I know she cannot alert me by noise if she needs the outside ...
    (rec.pets.cats.anecdotes)
  • File in Use Alert
    ... someone else opens the same file there is no alert like in Word or Excel. ... file in use alert in Publisher 2007? ... TIA, Terry ...
    (microsoft.public.publisher)
  • How to stop warning message when opening excel file in IE
    ... in order to open an excel file in IE. ... opens I receive a warning alert saying that this file coult contain a ... I need to block this alert. ... I already tried the command ...
    (microsoft.public.excel.programming)
  • Re: "Save as" dialogue box
    ... Dim myFile As String ... Dim PathToUse As String ... A peer in "peer to peer" support ... >> opens up ...
    (microsoft.public.word.docmanagement)
Quantcast