Update Links

[John Cole, Jr.]

In my workbook_open routine, I have "Application.AskToUpdateLinks =
False", and I'm getting the result I want. its not prompting for the
dialogue to update the links. However, the workbook contains links to
other sheets that are not opened yet, so I'm getting the dialogue that
states it can't update some links. I have the choice of the either
choosing Continue or Edit Links. How do I suppress that? I know how
to do it when I'm using a macro to open another workbook, but I'm
trying to suppress it on the workbook I'm opening with the
workbook_open routine. I haven't seen anything on this in the
groups. Nothing exists in the options. Application.displayalerts =
false isn't working either.

JC

 

[John Cole, Jr.]

I forgot to add that I'm using code later in the routine to update the
links. I just want it to always be Continue. If I choose "Edit
Links" it doesn't continue with the routine and the workbooks that I
need opened don't open.

JC