copy paste fail
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 ? |
copy paste fail
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. |
All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com