Help - my toolbars have disappeared

[ker]

I am looking for some help again. In excel, I opened a file which once
closed seems to have distorted the toolbars on excel. When I look in
tools customise, "standard" and "formatting" seem to have disappeared.
Does anyone know how I can get them back ? (If I try to create new
ones, it says that they already exist, even though I cannot find
them).

Thanks for your help.

 

[davidbrowne17]

right click anyware in the area where the toolbars should be, and then
re-select what toolbars you need.

 

[Ron de Bruin]

Run this macro Ker

Sub show()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = True
Next
End Sub

 

[ker]

Thanks for your help - however the actual words "standard" and
"formatting" are missing from the tool bar, so when I right click on
the mouse they are not there.