I am working on a customers excel file.
Currently, when I copy a cell, it gets selected. When I click on any other
cell to
paste, the selected cell loses it's selection, and I cannot Paste.
When I disable the Macros, I don't have this problem.
Any idea what the macros could be enabling or disabling to cause this.
Thanks.
Paul van coller
Dave Peterson - 24 Aug 2006 16:50 GMT
Lots of developers tie into events (like when you change selection or change a
cell) and have their code do something "important".
So that developer could be explicitly trying to stop you from pasting, but more
normally, lots of macros will clear the cutcopymode in excel. And you're just
suffering from that problem.
The solution is to disable all macros -- like you did.
Or temporarily disable event monitoring.
To try this:
hit alt-f8 (to get to the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.enableevents = false
When you're ready to go back to "normal", do the same thing, but change it to
true.
> I am working on a customers excel file.
>
[quoted text clipped - 9 lines]
>
> Paul van coller

Signature
Dave Peterson
Camper Joe - 24 Aug 2006 17:18 GMT
Hi Dave
Thank you very much
It worked like a bomb (without exploding).
Paul.
> Lots of developers tie into events (like when you change selection or change a
> cell) and have their code do something "important".
[quoted text clipped - 29 lines]
> >
> > Paul van coller
Kevin Vaughn - 24 Aug 2006 18:08 GMT
So it was a dud! j/k

Signature
Kevin Vaughn
> Hi Dave
>
[quoted text clipped - 37 lines]
> > >
> > > Paul van coller