Hi Bret,

I am sorry if I did not make it clear.
As Jim suggested, there is no such an event which will generate when we
are editing a cell.

Per your descritpion, you wanted to detect the edit status because if you
are trying to SaveCopyAs, you will get exception if the cell is in editing.

So my suggest is that, when we try to save a file, Workbook_BeforeSave
event will fire. Which gave us a chance to make sure the cell is not in the
edit mode, so that we the Save work will not generate exception.

If I misunderstood, please feel free to post there.



Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.