copy paste fail

[rumkus]

I don't know what causes this but sometimes "paste" option on the
right click is greyed.
Not always but it is very irritating. There are several macros
belonging to workbook. Can they be the reason ?
How can i make "paste" option functional again.
Any help ?

 

[rumkus]

Found it, trimming the code behind the sheet i want to paste to:


Private Sub Worksheet_Activate() <----------------------------No good
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
End With
Application.Goto Reference:=Cells(1, 1), Scroll:=True
ActiveSheet.Cells(2, 1).Select
End Sub


Private Sub Worksheet_Activate() <................................Good
Application.Goto Reference:=Cells(1, 1), Scroll:=True
ActiveSheet.Cells(2, 1).Select
End Sub

God knows why though.