Help - my toolbars have disappeared

  • Thread starter Thread starter ker
  • Start date Start date
K

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.
 
right click anyware in the area where the toolbars should be, and then
re-select what toolbars you need.
 
Run this macro Ker

Sub show()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = True
Next
End Sub
 
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.
 
Back
Top