Hi VJ,

Since a macro cannot run when Excel is in edit mode, it would not be
possible, programmatically, to deactivate the cell.

It is certainly possible to use VBA to insert a symbol - but not if Excel is
in edit mode.


---
Regards,
Norman



"vj5" <vj5@discussions.microsoft.com> wrote in message
news:27E913DA-D1DC-4C63-98B4-9FFB02E5DDBA@microsoft.com...
>i wanted to insert a symbol in a cell while cell is in edit mode. i
>alraedy
> post questions and goit reply its not possible.
> Now my question is that : if its not possible than how insert--symbol is
> working in excel.
> can i diactivate edit in cell and after inserting again activate edit in
> cell?
>