Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This code from Elkar when placed in VBE ThisWorkbook seems to do a nice job
preventing a user from cutting/pasting in a workbook. Is there a way I can modify it for use only on a certain range within one sheet? How about two non-continguous ranges on the same sheet? TIA Here is the code from another post (credits to Elkar): Private Sub Workbook_Activate() Application.CutCopyMode = None End Sub Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Application.CutCopyMode = None End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i prevent duplicate values in a range of validated cells? | Excel Discussion (Misc queries) | |||
How do I prevent duplicate numbers in a range of validated cells? | Charts and Charting in Excel | |||
Prevent changing size when copy&paste into another Excel Worksheet | Excel Worksheet Functions | |||
How do I prevent certain Paste options | Excel Discussion (Misc queries) | |||
prevent the copy and paste function | Excel Discussion (Misc queries) |