Hello,

I have an Excel "Master" file that I use to open a bunch of workbooks, make changes, then save the workbook. In each of the individual workbooks, there is code that shows a messagebox if the workbook is out of balance. I want to suppress this messagebox. The code I am using is:

VB Code:
  1. Workbooks(xTemplate).Close True
  2.         SendKeys "{Enter}"

The above code works fine for suppressing that messagebox, but it seems to be suppressing subsequent message boxes as well. How do I code it so the sendkey only applies to the above message?

Thank you.