worksheet functions

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

davidbrowne17


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

Ron

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