Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.DisplayStatusBar = True
Application.StatusBar = FileLen(ActiveWorkbook.FullName) / 1024 & " Ko."
End Sub
Private Sub Workbook_Deactivate()
Application.StatusBar = ""
End Sub
Bonjour
bonjour Kiki
codes à mettre dans l'évènement du classeur :
Code:Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.DisplayStatusBar = True Application.StatusBar = FileLen(ActiveWorkbook.FullName) / 1024 & " Ko." End Sub Private Sub Workbook_Deactivate() Application.StatusBar = "" End Sub