Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Paste special function in macros fail if we disable application cellDrap Drop | Excel Programming | |||
Automating copy/paste/paste special when row references change | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming |