View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ssissa@newsgroups.nospam is offline
external usenet poster
 
Posts: 2
Default 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