Can a macro after it runs return me to a cell in edit mode?
I made "rong entry of cell" runs a macro deponds on a cell that is
calculated (i used calculate event) and i don't want to delete the cell
contents but just edit in it instead of writing the whole entry agian
If i don't delete the entry in the biginning of macro it runs continously
until i break it
thanks

Please post your code.
--
HTH,
Barb Reinhardt



"Khaled" wrote:

> Can a macro after it runs return me to a cell in edit mode?
> I made "rong entry of cell" runs a macro deponds on a cell that is
> calculated (i used calculate event) and i don't want to delete the cell
> contents but just edit in it instead of writing the whole entry agian
> If i don't delete the entry in the biginning of macro it runs continously
> until i break it
> thanks

You can put this in before your End Sub statement, but realize you won't be
able to run any code while you're in edit mode. James

SendKeys "{F2}"

"Khaled" <(E-Mail Removed)> wrote in message
news:988169FC-9D89-4442-ACEB-(E-Mail Removed)...
> Can a macro after it runs return me to a cell in edit mode?
> I made "rong entry of cell" runs a macro deponds on a cell that is
> calculated (i used calculate event) and i don't want to delete the cell
> contents but just edit in it instead of writing the whole entry agian
> If i don't delete the entry in the biginning of macro it runs continously
> until i break it
> thanks

Thank you very
simple and right answer but great thanks

"Zone" wrote:

> You can put this in before your End Sub statement, but realize you won't be
> able to run any code while you're in edit mode. James
>
> SendKeys "{F2}"
>
> "Khaled" <(E-Mail Removed)> wrote in message
> news:988169FC-9D89-4442-ACEB-(E-Mail Removed)...
> > Can a macro after it runs return me to a cell in edit mode?
> > I made "rong entry of cell" runs a macro deponds on a cell that is
> > calculated (i used calculate event) and i don't want to delete the cell
> > contents but just edit in it instead of writing the whole entry agian
> > If i don't delete the entry in the biginning of macro it runs continously
> > until i break it
> > thanks
>
>
>