Catching edit mode error

C

c mateland

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
 
J

Jon Peltier

What's the entry point to your routines like? I've never heard of this
(though maybe my clients are being polite).

- Jon
 
C

c mateland

False alarm. It wasn't crashing. It was merely the macro buttons
became non-functioning. That, due to the user being in the edit mode
while trying to click a button. They just need more Excel basics, I
think.

Thanks,
Chuck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top