Avatar of tchristie33

asked on 

Workbook contains links to other data sources. Avoid this in excel VB

I have a code that runs and in it's process it has to open and work with certain files. However, some of them have links to other workbooks. Is there any command I can put in my code to not allow this workbook to stop the code and make the user answer whether to update or not update. I DO NOT WANT TO UPDATE! Also Applicaiton.screenupdating = false does not work nor does Application.displayalerts = false or the command that disables the keyboard and mouse. PLEASE DON'T suggest any of those as solutions. I greatly appreciate your help on tackling this issue. Thanks a ton...

Visual Basic ClassicMicrosoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon