Thread: Using VBA code to interact with or interrupt an external macro
View Single Post
 
Old 01-16-2018, 09:21 AM
TishyMouse TishyMouse is offline Windows XP Office 2007
Novice
  
Join Date: Feb 2012
Posts: 22
TishyMouse is on a distinguished road
Question Using VBA code to interact with or interrupt an external macro
I have a macro that is calling another macro in an external workbook (created by a third party so I don't have access to the macro source code). The external macro currently executes and finishes by displaying a 'Done' message box. Is there any way for me to (a) suppress the message box OR (b) pass a command to simulate pressing 'OK' on the message box OR (c) interrupt the external macro at this point?

Excel 2016 on Windows
Reply With Quote