cut cancel & open copy Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
 Kullanıcıların çalışma kitabını açtıklarında kesme/kopyalama ve yapıştırma komutlarını kullanamaz.
Sub DisableCutAndPaste()
  EnableControl 21, False   ' cut
  EnableControl 19, False   ' copy
  EnableControl 22, False   ' paste
  EnableControl 755, False  ' pastespecial
  Application.OnKey "^c", ""
  Application.OnKey "^v", ""
  Application.OnKey "+{DEL}", ""
  Application.OnKey "+{INSERT}", ""
  Application.CellDragAndDrop = False
End Sub
 ' BU KOD KISITLAMALARI AKTİF YAPAR
Sub EnableCutAndPaste()
  EnableControl 21, True   ' cut
  EnableControl 19, True   ' copy
  EnableControl 22, True   ' paste
  EnableControl 755, True  ' pastespecial
  Application.OnKey "^c"
  Application.OnKey "^v"
  Application.OnKey "+{DEL}"
  Application.OnKey "+{INSERT}"
  Application.CellDragAndDrop = True
End Sub

Sub EnableControl(Id As Integer, Enabled As Boolean)
  Dim CB As CommandBar
  Dim C As CommandBarControl
  For Each CB In Application.CommandBars
    Set C = CB.FindControl(Id:=Id, recursive:=True)
    If Not C Is Nothing Then C.Enabled = Enabled
  Next
End Sub

No	Macro Name
1	cut cancel & open copy
2	cut cancel & open copy
3	Increasing the number of cells called numfact on opening and closing
4	excel operators hk
5	userform perfect opening effect
6	Add menu to file edit bar delete
7	backup
8	cut copy paste cancel
9	active cell printing
10	printing and prompting
11	Cancel copy and paste
12	excelin all menu pushbutton pictures
13	closed book ontime
14	sheet / pages with toolbars and menus
15	do not open excel file after a certain date
16	perfectly deletes the menu to the right mouse and adds print print preview sheet / page structure
17	excellent menu insert file menu print print preview sheet / page structure remains
18	return one or more values in a macro
19	a .bat file from a floppy disk
20	cookie when file is opened

Excel Free Macros (VBA)

Cut Cancel & Open Copy

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords