Mot de passe du projet VBA

Bonjour Romuald
Oui, ci-dessous code de Chip Pearson http://www.cpearson.com/excel.htm
Cordialement
Pascal


Sub TestProtect()
ProtectVBProject Workbooks("Proteger_deproteger.xls"), "MotdePasse"
End Sub

Sub TestUnprotect()
UnprotectVBProject Workbooks("Proteger_deproteger.xls"), "MotdePasse"
End Sub

Sub UnprotectVBProject(WB As Workbook, ByVal Password As String)
Dim vbProj As Object

Set vbProj = WB.VBProject

'can't do it if already unlocked!
If vbProj.Protection <> 1 Then Exit Sub

Set Application.VBE.ActiveVBProject = vbProj

' now use lovely SendKeys to quote the project password
SendKeys Password & "~~"
Application.VBE.CommandBars(1).FindControl(ID:%78,
recursive:=True).Execute
End Sub

Sub ProtectVBProject(WB As Workbook, ByVal Password As String)
Dim vbProj As Object

Set vbProj = WB.VBProject

'can't do it if already locked!
If vbProj.Protection = 1 Then Exit Sub

Set Application.VBE.ActiveVBProject = vbProj

' now use lovely SendKeys to set the project password
SendKeys "+{TAB}{RIGHT}%V{+}{TAB}" & Password & "{TAB}" & _
Password & "~"

Application.VBE.CommandBars(1).FindControl(ID:%78,
recursive:=True).Execute

WB.Save
End Sub

"Romuald" <rcolletaz@hotmail.com> a écrit dans le message de
news:225201c3af41$bec39690$a601280a@phx.gbl...
Bonjour,

est-il possible de définir le mot de passe du projet VBA
via le code?

merci!