View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default how to disable copy paste buttons from from edit menu

Not easily. It requires a fair bit of VBA code including event coding and
strong error handling to ensure that the Copy Paste functionallity always
gets restored no matter what. Unless you are fairly confident in your VBA I
would recomend against it. what might be easier would be to add this code
which cancels a copy when the cursor is moved...

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.CutCopyMode = False
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
Application.CutCopyMode = False
End Sub


Add this code to ThisWorkbook (Right click the Excel Icon next to File in
the Menu and select View Code... Paste the above code.)
--
HTH...

Jim Thomlinson


"excel test" wrote:

how to disable copy paste buttons from from edit menu only for a given
workbook?