Prev: Automatically Sorting of Excel Records
Next: Projecto VBA
From: rumkus on 24 Feb 2010 08:46
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 ?
From: rumkus on 25 Feb 2010 07:38
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.
 | 
Pages: 1
Prev: Automatically Sorting of Excel Records
Next: Projecto VBA