How do I detect and commit the current cell edition?
Hi Peter,
Thanks for your help.
I didn't follow exactly how your suggestion can help me, and I haven't had a
chance yet to play further on your ideas.
I can see that Cells(1,1).Select() will probably end any editing action to
move the selection. However this is not acceptable for me, because if the
user has a normal selection, I don't want to disrupt it. I didn't follow how
you were first detecting the edit mode? Are you suggesting that I can test if
a certain menu button is disabled?
Thanks,
Bret
|