I
Ian Digby
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
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