don't know if it works.

try to push a Esc key programmatically, code as below:

Application.OnKey "{ESC}"


let me know if it is working or not.

regards

Leung



"ARHangel" wrote:

I attach to Excel Application event WorkbookActivate a method in witch I call
SaveAsCopy. I have search the internet and I found that this error ocurrs
because a cell is in edit mode. So my question is how can I end edit of the
cell so this error will not ocurr again.