From: Ian Digby Ian on
Here's a weird thing:

1. Inexplicably, after running some farily standard VBA code, my Excel
application was left in DataEntryMode , thus disabling various menu options.

2. The last line of my code was:
MsgBox "Update Complete.", vbInformation

3. Tried turning off DataEntryMode - problem persisted.
2. Tried issuing an escape keystroke, after the MsgBox:
SendKeys "{ESC}", True
Problem persisted.

3. Moved the SendKeys line to run before the MsgBox, and it works fine.

Comments?

Ian Digby, Meggitt