Copy Functionality Lost

[Charles]

Up until a day or two ago, I could select a cell to copy, paste it into
another cell and the original copied cell would remain available to be copied
again (it would be highlighted with the dotted border).

Now, after one paste the copy cell reverts to normal, and I have to
re-select it to copy into another location.

I know I can use CTRL or SHIFT, but I find the retention of the copy ability
useful.

This is a networked office PC and imagine I might have to ask our IT Dept
(as Administrator) to do something.

Any ideas appreciated, thanks

 

[Jim Rech]

If you paste by pressing Enter you'll exit Copy mode. If you paste via
Ctrl-v you should stay in Copy mode.

--
Jim
| Up until a day or two ago, I could select a cell to copy, paste it into
| another cell and the original copied cell would remain available to be
copied
| again (it would be highlighted with the dotted border).
|
| Now, after one paste the copy cell reverts to normal, and I have to
| re-select it to copy into another location.
|
| I know I can use CTRL or SHIFT, but I find the retention of the copy
ability
| useful.
|
| This is a networked office PC and imagine I might have to ask our IT Dept
| (as Administrator) to do something.
|
| Any ideas appreciated, thanks

 

[Charles]

Hi Jim

That doesn't work anymore either; no matter which way I copy - Keyboard,
Mouse or Menu - I can only copy once.

 

[Jim Rech]

I'd next guess that code is running when you paste. Right click the
worksheet tab and pick View Code. If you see any code in the module that
appears look for a sub named Worksheet_Change. This routine would run when
you paste and it may be clearing the clipboard. It could be another sub
though, e.g., Worksheet_SelectionChange. If you don't see anything then I
don't know what's going on.

--
Jim
| Hi Jim
|
| That doesn't work anymore either; no matter which way I copy - Keyboard,
| Mouse or Menu - I can only copy once.
|
| "Jim Rech" wrote:
|
| > If you paste by pressing Enter you'll exit Copy mode. If you paste via
| > Ctrl-v you should stay in Copy mode.
| >
| > --
| > Jim
| > | > | Up until a day or two ago, I could select a cell to copy, paste it
into
| > | another cell and the original copied cell would remain available to be
| > copied
| > | again (it would be highlighted with the dotted border).
| > |
| > | Now, after one paste the copy cell reverts to normal, and I have to
| > | re-select it to copy into another location.
| > |
| > | I know I can use CTRL or SHIFT, but I find the retention of the copy
| > ability
| > | useful.
| > |
| > | This is a networked office PC and imagine I might have to ask our IT
Dept
| > | (as Administrator) to do something.
| > |
| > | Any ideas appreciated, thanks
| >
| >
| >

 

[Charles]

Hi Jim

Thanks for your help.

I thought it was an Excel problem, but infact it is only the one workbook I
am using at the moment. I will check for the codes you suggest.

Regards

 

[Charles]

Jim

I did find the Worksheet_Change and removed the routine.

Everything is back to how I like it.

Your help is really appreciated, especially as I was looking in completely
the wrong direction!

Regards

 

[13vespa13]

Hi Jim,
A few people on my team at work are having this same problem. They are
unable to paste into Excel from another source and unable to copy from Excel
to another source. I am not experienced with the code, so I don't want to do
anything that could jeopardize the integrity of the sheet. I do see Private
Sub Worksheet_Activate() in the tab. Do I simply delete that, or is there
something more specific I should do?
Thank you in advance for your help,
Amy