View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
c mateland c mateland is offline
external usenet poster
 
Posts: 52
Default Catching edit mode error

Excel 2003

Several of my users have crashed my routines because they clicked one
of my macro buttons while still in the cell-edit mode. I correct them
and include the warning in helps and training, but still I see this
happen over and over.

Is there any way I can programmatically check for the edit mode or add
some kind of error handler that can catch that error specifically? How
do the rest of you handle this?

Thanks,
Chuck