Option Explicit
Dim User As String
Private Sub Workbook_Open()
User = Environ("username")
If User = "BrunoM45" Then
' Désactiver le menu
Application.CommandBars("Edit").Controls("Couper").Enabled = False
Application.CommandBars("Edit").Controls("Copier").Enabled = False
Application.CommandBars("Edit").Controls("Coller").Enabled = False
' Désactiver la barre d'outils:
Application.CommandBars("Standard").Controls("Couper").Enabled = False
Application.CommandBars("Standard").Controls("Copier").Enabled = False
Application.CommandBars("Standard").Controls("Coller").Enabled = False
' Désactiver le menu contextuel
Application.CommandBars("Cell").Controls("Couper").Enabled = False
Application.CommandBars("Cell").Controls("Copier").Enabled = False
Application.CommandBars("Cell").Controls("Coller").Enabled = False
' Désactiver ShortcutKeys:
Application.OnKey "^c", ""
Application.OnKey "^v", ""
Application.OnKey "^x", ""
End If
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
User = Environ("username")
If User = "BrunoM45" Then
' Activer le menu
Application.CommandBars("Edit").Controls("Couper").Enabled = True
Application.CommandBars("Edit").Controls("Copier").Enabled = True
Application.CommandBars("Edit").Controls("Coller").Enabled = True
' Activer la barre d'outils:
Application.CommandBars("Standard").Controls("Couper").Enabled = True
Application.CommandBars("Standard").Controls("Copier").Enabled = True
Application.CommandBars("Standard").Controls("Coller").Enabled = True
' Activer le menu contextuel
Application.CommandBars("Cell").Controls("Couper").Enabled = False
Application.CommandBars("Cell").Controls("Copier").Enabled = False
Application.CommandBars("Cell").Controls("Coller").Enabled = False
' Activer ShortcutKeys:
Application.OnKey "^c"
Application.OnKey "^v"
Application.OnKey "^x"
End If
End Sub