does anyone know how to automate clicking continue on a error for a missing link? I get a error dialog box but as soon as i click continue the error the value goes away. i was wondering is there away to catch this error in vba and just make it carry through?