Sub ClrBar()
'masque les menus et barres d'outils
For Each o In CommandBars
o.Enabled = False
Next
End Sub
Sub RstBar()
'affiche les menus et barre d'outils
For Each o In CommandBars
o.Enabled = True
Next
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
RstBar
End Sub
Private Sub Workbook_Open()
ClrBar
End Sub