>
Sub Consolid()
Dim img As Object
If MsgBox("ATTENTION," & vbCr & "après avoir accepté la clôture de cet exercice," & vbCr & "il ne vous sera plus possible de le modifier." _
& vbCr & vbCr & "VOULEZ-VOUS CONTINUER ?", vbYesNo + vbExclamation, "CLOTURE COMPTE") = vbNo Then Exit Sub
With ActiveWorkbook.VBProject.VBComponents(ActiveWorkbook.Sheets _
(ActiveSheet.Name).CodeName).CodeModule
.DeleteLines 1, .CountOfLines
.CodePane.Window.Close
End With
For Each img In ActiveSheet.Shapes
img.Delete
Next
End Sub