Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Catching edit mode error
What's the entry point to your routines like? I've never heard of this
(though maybe my clients are being polite). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "c mateland" wrote in message ups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Catching edit mode error
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 On Jun 8, 8:29 pm, "Jon Peltier" wrote: What's the entry point to your routines like? I've never heard of this (though maybe my clients are being polite). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Catching an error | Excel Programming | |||
globally catching any error event? | Excel Programming | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
Edit mode | Excel Programming | |||
Catching an error | Excel Programming |