View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc[_15_] Marc[_15_] is offline
external usenet poster
 
Posts: 3
Default Detecting Cell Edit Mode

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?