Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

Problem in Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Camper Joe - 24 Aug 2006 15:16 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.