Detecting Cell Edit Mode

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I have a COM module that fires events at an Excel VBA class, the event need
to update a worksheet, but when the user is editing a cell the update fails
with Application Error.

Is there any way to detect wether a user is editing a cell (without trying
to update one) and Cancel the users edit (maybe prompt first) so the update
can go ahead?
 
Back
Top