Can't Undo Paste

[rockets2010]

Hello,

I have an Excel document in which I cannot undo pasting after both copy+paste and cut+paste. I can open a new document and am able to undo paste, but for some reason this particular document won't let me. As you can imagine, this has the potential to really screw up your work if you accidently paste something where you didn't mean to. The workbook has no macros running.

Running Excel 2010.

Thanks for your help.

[ChemistB]

It does sound as if there is VBA code running in the background. If you right click on the sheet tab and "View Code" is there any code there?

[rockets2010]

Yes, the following is present:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

[ChemistB]

Is there nothing between the two lines? If not, erase it. That is causing your problem.

[rockets2010]

Nothing is present between the lines. The below code is also present on the ThisWorkbook screen. Also, how do I delete. It seems not to be as simple as deleting the code and exiting VBA

Private Sub Workbook_Open()

End Sub

[ChemistB]

Yep, it is that simple. Select it and backspace or clear or delete. Then close the screen. Might as well Clear the Workbook open screen too although that's not bothering you.

[rockets2010]

OK, thanks very much for your help but the problem is still there. To clarify, the code I posted earlier from the module is under the "worksheet" drop down menu rather than the "general" menu. When I delete it, it just takes me back to the general menu, and the code is still there on the worksheet menu.

[ChemistB]

Ahhh, okay, when you go to that worksheet dropdown menu, it (Excel) automatically assumes you are planning on writing code and it supplies the first and last line for you. Once you clear it, Excel brings you back to the "General" menu. Don't go back into the Worksheet menu. If you are still having problems, then the problem is elsewhere. I don't suppose you can upload your spreadsheet (clearing off any propriatary information first)?

[rockets2010]

I see. Unfortunately problem is still there. I wish I could upload but the whole doc is basically proprietary so it would be too difficult. Another aspect of the problem I just noticed is that the issue only occurs on some sheets within the workbook. On others, there is no copy paste problem. Not sure if this gives you any new ideas...

[romperstomper]

Is there code behind the sheets that do have the problem? Alternatively, if you open the workbook with macros disabled, does the problem go away?

[rockets2010]

There is no code behind the sheets. The problem must be somewhere else.

[romperstomper]

And the answer to my second question?

[rockets2010]

No luck with that suggestion either. What I just did to fix it was to move each of the sheets to a new workbook. The problem seems to have gone away in the new document.

[ChemistB]

Can you upload the old spreadsheet, even if it's empty and the problem persists. I'd like to try to solve this.

[rockets2010]

Wish I could...against company policy, etc. Sorry I can't be a team player on this one, but thanks very much for your help with this.

[zerozero]

I have got the same problem. Anyone want the example file and further details? All the data can be removed and so far the problem remains

Other issues is that cut/insert row/columns doesn't work or validation lists so a number of things seem to get messed up and it does appear to be permanant.

Moving/copying the sheets into a new file works although if you have tables you have to do each one individually which is somewhat painful.

[ChemistB]

Yes, start a new thread though (rule 2)