Paste Function Stopped Working.

**modytrane** · 10-19-2010, 03:47 PM

I created a workbook that required lot of Worksheet_SelectionChange and a small Worksheet_Change event programming. Somewhere along the line I must have done something that has made the paste function not work anymore.
Here's the code in Worksheet_SelectionChange event.

Please Login or Register  to view this content.

And here's the code for the enable routine.

Please Login or Register  to view this content.

I don't know what causes this problem but when I select a cell [data or formula], right click, copy the cell gets the scrolling dashed line around it. Then when I go to another cell [where I want to paste] and select it the Paste icon on the toolbar goes light and on the right button meny the Paste choice is greyed out.

Is there a setting that I can change?

Thanks for any help or suugestion.

modytrane.

**opsman** · 10-19-2010, 05:56 PM

Have you tried CTRL and V together to paste? Perhaps not the answer you're looking for, but I have come across pages before where the normal copy and paste conventions don't work, but CTRL and V still works (v in lower case).

**opsman** · 10-19-2010, 06:00 PM

Oooops....sorry are you talking about it being integrated into an app you're writing or simply to paste (apologies if it seems like real suck eggs reply!)

**modytrane** · 10-20-2010, 10:45 AM

I figured it out. Found a way around it for now.
It was the Worksheet_SelectionChange event. Because it triggers every time you make a selection, the initial Copy command which turns on the Paste function gets negated and the paste fucntion is no longer available. I had to circumvent that by creating another Macro that sets EnableEvents to False when you want to be in programming mode.

Thanks for your response. If anyone has other ideas I would welcome them.

I'll leave this thread open for a while and in two weeks mark it SOLVED.

modytrane.

**opsman** · 10-20-2010, 07:00 PM

modytrane

No problem, you might be better posting this kind of question to the VBA specific forum, rather than the general page. They tend to be more specialist in this type of problem.

**smichael** · 02-17-2011, 12:15 PM

Originally Posted by modytrane

I figured it out. Found a way around it for now.
It was the Worksheet_SelectionChange event. Because it triggers every time you make a selection, the initial Copy command which turns on the Paste function gets negated and the paste fucntion is no longer available. I had to circumvent that by creating another Macro that sets EnableEvents to False when you want to be in programming mode.

Thanks for your response. If anyone has other ideas I would welcome them.

I'll leave this thread open for a while and in two weeks mark it SOLVED.

modytrane.

Hi modytrane,

I'm having the same problem, but can't figure out how to apply your solution. Here's my Worksheet_SelectionChange event:
Option Explicit

Private Sub worksheet_selectionchange(ByVal target As Excel.Range)
With ActiveWindow.VisibleRange
Me.TextBox1.Top = .Top
Me.TextBox1.Left = .Left
End With
End Sub

What exactly do I need to add to get the Paste function to work again?

Many thanks, as this is driving me nuts!