Problem in Excel
 

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

Problem in Excel
 

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.



Camper Joe wrote:

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

Problem in Excel
 

Hi Dave

Thank you very much

It worked like a bomb (without exploding).

Paul.

"Dave Peterson" wrote:

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.



Camper Joe wrote:

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

Problem in Excel
 

So it was a dud! j/k
--
Kevin Vaughn


"Camper Joe" wrote:

Hi Dave

Thank you very much

It worked like a bomb (without exploding).

Paul.

"Dave Peterson" wrote:

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.



Camper Joe wrote:

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