Lost menu items on toolbar

[Ms Excel]

Hi,

I lost some items on my toolbar. The Insert is showing but when I click it, it has only a few items there, without the rows, columns, etc. thus I cannot insert a row.
The Data option is also gone. I don't know what happened. Can you help please?

Thanks.

 

[Ms Excel]

Hi,

I now know why I lost certain menu items on the toolbar because I put in the macro below in a workbook. Once I open this workbook, certain menu items are there but if I open another Excel workbook, the menu items under Insert, for example are not all showing. When the Excel application is closed and then opened, the menu items for Insert are all there. Do you know why this macro will result in the menu items for Insert to disappear?

Private Sub Workbook_Open()
With Application
.DisplayFormulaBar = False
.DisplayStatusBar = False
.CommandBars("Standard").Visible = False
.CommandBars("Formatting").Visible = False
.CommandBars("Chart Menu Bar").Visible = False
.CommandBars("Control Toolbox").Visible = False
End With
End Sub


Private Sub Workbook_Deactivate()
With Application
.DisplayFormulaBar = True
.DisplayStatusBar = True
.CommandBars("Standard").Visible = True
.CommandBars("Formatting").Visible = True
.CommandBars("Chart Menu Bar").Visible = True
.CommandBars("Control Toolbox").Visible = False
End With
End Sub