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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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" <jonxlmv...@SPAMpeltiertech.com>
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
> _______