Private Sub Workbook_Open() 'Grise Options à l'ouverture de ton fichier
nomBarre = 'Worksheet menu bar'
Set NewMenu = Application.CommandBars(nomBarre).Controls('&Outils')
NewMenu.Controls('&Options...').Enabled = False
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean) 'Retabli
nomBarre = 'Worksheet menu bar'
Set NewMenu = Application.CommandBars(nomBarre).Controls('&Outils')
NewMenu.Controls('&Options...').Enabled = True
End Sub