Board index » Excel » Help - my toolbars have disappeared

Help - my toolbars have disappeared

Excel13
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.





------------------------------------------------

~~ Message posted from http://www.ExcelTip.com/

~~View and post usenet messages directly from http://www.ExcelForum.com/


-
 

Re:Help - my toolbars have disappeared



right click anyware in the area where the toolbars should be, and then

re-select what toolbars you need.





------------------------------------------------

~~ Message posted from http://www.ExcelTip.com/

~~View and post usenet messages directly from http://www.ExcelForum.com/



-

Re:Help - my toolbars have disappeared

Run this macro Ker



Sub show()

Dim bar As CommandBar

For Each bar In Application.CommandBars

bar.Enabled = True

Next

End Sub





--

Regards Ron de Bruin

(Win XP Pro SP-1 XL2002 SP-2)

www.rondebruin.nl







"ker" <ker.wgu7b@excelforum-nospam.com>wrote in message news:ker.wgu7b@excelforum-nospam.com...

Quote


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.





------------------------------------------------

~~ Message posted from http://www.ExcelTip.com/

~~View and post usenet messages directly from http://www.ExcelForum.com/







-