Hello all. I am getting very frustrated not being able to get around
this. Is there a way in VBA to either:

1) Turn off the pop up box "File Not Found" when opeing a
workbook somehow? Kind of along the same lines as
application.screenupdating = false

2) I know there are certain codes that pertain to the
updatelinks that range from 0-3. Mine is currently obviously set to
3, and I need it set to 1, where it only updates EXTERNAL links,
because there are both worksheet & remote links.

or...

3) Use VBA to simply press a cancel button for a pop up
window?

Essentially I just don't want my users to have to press cancel upon
opeing the workbook. The workbook is far to extensive to weed through
and gather all links within.

any suggestions would be greatly appreciated!
thanks!

Clean up the workbook so all the files are found or remove the link.

Look under Edit=Links for available options (in xl2002 and later)

--
Regards,
Tom Ogilvy



" wrote:

Hello all. I am getting very frustrated not being able to get around
this. Is there a way in VBA to either:

1) Turn off the pop up box "File Not Found" when opeing a
workbook somehow? Kind of along the same lines as
application.screenupdating = false

2) I know there are certain codes that pertain to the
updatelinks that range from 0-3. Mine is currently obviously set to
3, and I need it set to 1, where it only updates EXTERNAL links,
because there are both worksheet & remote links.

or...

3) Use VBA to simply press a cancel button for a pop up
window?

Essentially I just don't want my users to have to press cancel upon
opeing the workbook. The workbook is far to extensive to weed through
and gather all links within.

any suggestions would be greatly appreciated!
thanks!