Barrie, here's another one for you. Thnx in advance.

[Barry Katcher]

Another annoying message box that pops up when I open my summary Workbook is "The Workbook you opened contains automatic links to info in another Workbook, etc, etc....Update (Yes) or (No).

Is there code to click "Yes"?

The line of code to open the subsid. w/b is "Workbook.Open Filename:="G......filename.xls", Password:="elf"

Do I use (True) somewhere?

 

[Barrie Davidson]

On 2002-03-08 09:19, Barry Katcher wrote:
Another annoying message box that pops up when I open my summary Workbook is "The Workbook you opened contains automatic links to info in another Workbook, etc, etc....Update (Yes) or (No).

Is there code to click "Yes"?

The line of code to open the subsid. w/b is "Workbook.Open Filename:="G......filename.xls", Password:="elf"

Do I use (True) somewhere?

Nope, sorry but if you have links in the file you will be prompted to update even if you have "displayalerts" set to false.


Regards,

 

[Escalus]

On 2002-03-08 09:19, Barry Katcher wrote:
Another annoying message box that pops up when I open my summary Workbook is "The Workbook you opened contains automatic links to info in another Workbook, etc, etc....Update (Yes) or (No).

Is there code to click "Yes"?

The line of code to open the subsid. w/b is "Workbook.Open Filename:="G......filename.xls", Password:="elf"

Do I use (True) somewhere?

You can disable this message box for all files by going to Tools>Options>Edit and un-checking AskToUpdateAutomaticLists.

Or if you want to disable it only before your macro opens your susid. w/b and enable it immediately thereafter, put this in your macro :-

Application.AskToUpdateLinks = False
Workbook.Open Filename:="G......filename.xls", Password:="elf"
Application.AskToUpdateLinks = True

 

[Barrie Davidson]

On 2002-03-08 15:39, Escalus wrote:

Or if you want to disable it only before your macro opens your susid. w/b and enable it immediately thereafter, put this in your macro :-

Application.AskToUpdateLinks = False
Workbook.Open Filename:="G......filename.xls", Password:="elf"
Application.AskToUpdateLinks = True

Thanks for showing me something I did not know.

A note for Barry Katcher - this will eliminate that annoying message box, but the links will be updated without notifying the user. So....if your links are no good you will have problems.

Regards,

 

[Barry Katcher]

Escalus, thanx a lot, worked perfectly.

Barrie, must be the Canadian spelling.