ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bypass information (https://www.excelbanter.com/excel-programming/438163-bypass-information.html)

Gotroots

Bypass information
 
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.


Luke M

Bypass information
 
Application.DisplayAlerts = False

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

Luke M
*Remember to click "yes" if this post helped you!*


"gotroots" wrote:

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.



All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com