Hi,

Don't forhget to enable them in workboo_before close

Private Sub Workbook_Open()
Application.CommandBars("standard").Enabled = False
Application.CommandBars("format").Enabled = False
Application.CommandBars("drawing").Enabled = False
End Sub

Mike


"pswanie" wrote:

what code would i enter to have the standard, formating, drawing toolbars be
disabled when a work book open? (right click on edit.... etc)