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?
|