Bypass information

G

gotroots

Hi,

'This workbook contains one or more links that cannot be updated.'

Button1: Continue
Button2: Edit Links...

The above msgbox prevents code from fully executing, what is the code
required to accept Button1: Continue and allow the code to continue its
execution.

Thank you for any help given.
 
L

Luke M

Application.DisplayAlerts = False

This will ignore the alert message, and continue on its merry way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing addin through VBA causes code to stop 2
XL03: Avoid "workbook contains links" msg when opening 5
User Intervention Required When Opening Workbooks 1
Update Links Stopping Workbook_Open Routine 1
Avoid "...contains one or more links that cannot be updated" message. 1
Modification of Recorded Macro 4
Links cannot be updated 1
Absolute Beginner and Timer Class 4

Top