Cancel copy and paste <! --- cancel copy paste Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
'Bu komutları çalışacağınız sayfanın kod bölümüne yazın. Modüle yazmayın.
Private Sub Workbook_Activate()

Dim oCtrl As Office.CommandBarControl

'Disable all Cut menus

For Each oCtrl In Application.CommandBars.FindControls(ID:=21)

oCtrl.Enabled = False

Next oCtrl

'Disable all Copy menus

For Each oCtrl In Application.CommandBars.FindControls(ID:=19)

oCtrl.Enabled = False

Next oCtrl

Application.CellDragAndDrop = False

End Sub

Private Sub Workbook_Deactivate()

Dim oCtrl As Office.CommandBarControl

'Enable all Cut menus

For Each oCtrl In Application.CommandBars.FindControls(ID:=21)

oCtrl.Enabled = True

Next oCtrl

'Enable all Copy menus

For Each oCtrl In Application.CommandBars.FindControls(ID:=19)

oCtrl.Enabled = True

Next oCtrl

Application.CellDragAndDrop = True

End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

With Application

.CellDragAndDrop = False

.CutCopyMode = False 'Clear clipboard

End With

End Sub

No	Macro Name
1	Cancel copy and paste
2	backup
3	cut copy paste cancel
4	excelin all menu pushbutton pictures
5	cut cancel & open copy
6	cut cancel & open copy
7	excel operators hk
8	Copy and paste any Excel sheet into another Excel file
9	return one or more values in a macro
10	inserts months as sheet / pages Specifies days in detail
11	special gluing options / format gluing design gluing formula gluing column width gluing transpose gluing
12	Using format painter to fit the format into a specific cell
13	Paste cells as values
14	Selecting the file name from the folder
15	copy-paste blocking
16	Assign another command to the right mouse button
17	Increasing the number of cells called numfact on opening and closing
18	m-n and o cell
19	pushbutton pictures
20	specify the number of copies to print from the printer

Excel Free Macros (VBA)

Cancel Copy And Paste

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords