Problem in Excel

[Guest]

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]

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.

 

[Guest]

Hi Dave

Thank you very much

It worked like a bomb (without exploding).

Paul.

 

[Guest]

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

Hi Dave

Thank you very much

It worked like a bomb (without exploding).

Paul.