User Intervention Required When Opening Workbooks

Hi,

We're writing a macro that opens a number of workbooks and creates
links to their cells in a master data sheet, and then closes them. The
issue arises when the sheet we are opening contains links to external
sheets. The "This workbook contains one or more links that cannot be
updated." "Continue" or "Edit Links" dialog box comes up. At this point
the user has to click Continue for the macro to keep functioning.

Naturally this defeats the purpose of the macro, does anyone know the
way around this ?

Thanks,
Rob.

try the line
application.displayalerts = false
...... code here
application.displayalerts = true

--
When you lose your mind, you free your life.


"Rob Fernando" wrote:

> Hi,
>
> We're writing a macro that opens a number of workbooks and creates
> links to their cells in a master data sheet, and then closes them. The
> issue arises when the sheet we are opening contains links to external
> sheets. The "This workbook contains one or more links that cannot be
> updated." "Continue" or "Edit Links" dialog box comes up. At this point
> the user has to click Continue for the macro to keep functioning.
>
> Naturally this defeats the purpose of the macro, does anyone know the
> way around this ?
>
> Thanks,
> Rob.
>
>