How to answer a ? in VBA
Posted by Marcie on August 17, 2001 8:06 AM
I currently have an automated process running that updates multiple workbooks (VBA Code) with the data from a master workbook. My user has made a change and now one of the workbooks to be updated comes up with a question (on open) "the workbook you opened contains automatic links to info in other workbooks..." Then it has a Yes or No prompt. Is there any way to handl this in the VBA code? I want to automatically answer "NO" to the question and not have my automated program stop when it comes to this workbook as it does now.