Excel worksheet Menu Toolbar

[Mikey]

I lost my Menu Toolbar and can't find it. The Standard & Formatting
toolbars with icons are still at top of worksheet. I can use the Alt = F, E
etc to get some items to open but need the Menu items back. It is "checked"
in the toolbars listing but it does nothing to "uncheck" it either.
Suggestions please.
--
Mickey

[Ardus Petus]

In VBE immediate window (Alt-F11 then Ctrl-g), type:
commandbars("worksheet menu bar").Reset

That should help

--
AP

"Mikey" <[email protected]> a écrit dans le message de news:
[email protected]...
>I lost my Menu Toolbar and can't find it. The Standard & Formatting
> toolbars with icons are still at top of worksheet. I can use the Alt = F,
> E
> etc to get some items to open but need the Menu items back. It is
> "checked"
> in the toolbars listing but it does nothing to "uncheck" it either.
> Suggestions please.
> --
> Mickey

[Mikey]

No help. I can access the Tools Customize function by right clicking on the
blank menu bar at top. It has all the various toolbars listed and the
Worksheet Menu bar IS checked but doesn't show up above the Icon buttons.
Other suggestions? I can't function without it.
--
Mickey


"Ardus Petus" wrote:

> In VBE immediate window (Alt-F11 then Ctrl-g), type:
> commandbars("worksheet menu bar").Reset
>
> That should help
>
> --
> AP
>
> "Mikey" <[email protected]> a écrit dans le message de news:
> [email protected]...
> >I lost my Menu Toolbar and can't find it. The Standard & Formatting
> > toolbars with icons are still at top of worksheet. I can use the Alt = F,
> > E
> > etc to get some items to open but need the Menu items back. It is
> > "checked"
> > in the toolbars listing but it does nothing to "uncheck" it either.
> > Suggestions please.
> > --
> > Mickey
>
>
>

[Ardus Petus]

Maybe your menu bar is located outside the screen.
In Immediate window, try:

set cb = commandbars("worksheet menu bar")
cb.top=0
cb.left=0

HTH
--
AP

"Mikey" <[email protected]> a écrit dans le message de news:
[email protected]...
> No help. I can access the Tools Customize function by right clicking on
> the
> blank menu bar at top. It has all the various toolbars listed and the
> Worksheet Menu bar IS checked but doesn't show up above the Icon buttons.
> Other suggestions? I can't function without it.
> --
> Mickey
>
>
> "Ardus Petus" wrote:
>
>> In VBE immediate window (Alt-F11 then Ctrl-g), type:
>> commandbars("worksheet menu bar").Reset
>>
>> That should help
>>
>> --
>> AP
>>
>> "Mikey" <[email protected]> a écrit dans le message de
>> news:
>> [email protected]...
>> >I lost my Menu Toolbar and can't find it. The Standard & Formatting
>> > toolbars with icons are still at top of worksheet. I can use the Alt =
>> > F,
>> > E
>> > etc to get some items to open but need the Menu items back. It is
>> > "checked"
>> > in the toolbars listing but it does nothing to "uncheck" it either.
>> > Suggestions please.
>> > --
>> > Mickey
>>
>>
>>

[Mikey]

That did it! Thanks a bunch. How did it happen though? And the one that
was displayed wasn't modified with the additional items I added to it such as
"page setup" and the "freeze panes" icon. I looked for *.xlb files which
some help site said contained the modified toolbar configuration but didn't
find anything. Other comments welcomed.
--
Mickey


"Ardus Petus" wrote:

> Maybe your menu bar is located outside the screen.
> In Immediate window, try:
>
> set cb = commandbars("worksheet menu bar")
> cb.top=0
> cb.left=0
>
> HTH
> --
> AP
>
> "Mikey" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > No help. I can access the Tools Customize function by right clicking on
> > the
> > blank menu bar at top. It has all the various toolbars listed and the
> > Worksheet Menu bar IS checked but doesn't show up above the Icon buttons.
> > Other suggestions? I can't function without it.
> > --
> > Mickey
> >
> >
> > "Ardus Petus" wrote:
> >
> >> In VBE immediate window (Alt-F11 then Ctrl-g), type:
> >> commandbars("worksheet menu bar").Reset
> >>
> >> That should help
> >>
> >> --
> >> AP
> >>
> >> "Mikey" <[email protected]> a écrit dans le message de
> >> news:
> >> [email protected]...
> >> >I lost my Menu Toolbar and can't find it. The Standard & Formatting
> >> > toolbars with icons are still at top of worksheet. I can use the Alt =
> >> > F,
> >> > E
> >> > etc to get some items to open but need the Menu items back. It is
> >> > "checked"
> >> > in the toolbars listing but it does nothing to "uncheck" it either.
> >> > Suggestions please.
> >> > --
> >> > Mickey
> >>
> >>
> >>
>
>
>

[Ardus Petus]

Glad I could help!

Cheers,
--
AP

"Mikey" <[email protected]> a écrit dans le message de news:
[email protected]...
> That did it! Thanks a bunch. How did it happen though? And the one that
> was displayed wasn't modified with the additional items I added to it such
> as
> "page setup" and the "freeze panes" icon. I looked for *.xlb files which
> some help site said contained the modified toolbar configuration but
> didn't
> find anything. Other comments welcomed.
> --
> Mickey
>
>
> "Ardus Petus" wrote:
>
>> Maybe your menu bar is located outside the screen.
>> In Immediate window, try:
>>
>> set cb = commandbars("worksheet menu bar")
>> cb.top=0
>> cb.left=0
>>
>> HTH
>> --
>> AP
>>
>> "Mikey" <[email protected]> a écrit dans le message de
>> news:
>> [email protected]...
>> > No help. I can access the Tools Customize function by right clicking
>> > on
>> > the
>> > blank menu bar at top. It has all the various toolbars listed and the
>> > Worksheet Menu bar IS checked but doesn't show up above the Icon
>> > buttons.
>> > Other suggestions? I can't function without it.
>> > --
>> > Mickey
>> >
>> >
>> > "Ardus Petus" wrote:
>> >
>> >> In VBE immediate window (Alt-F11 then Ctrl-g), type:
>> >> commandbars("worksheet menu bar").Reset
>> >>
>> >> That should help
>> >>
>> >> --
>> >> AP
>> >>
>> >> "Mikey" <[email protected]> a écrit dans le message de
>> >> news:
>> >> [email protected]...
>> >> >I lost my Menu Toolbar and can't find it. The Standard & Formatting
>> >> > toolbars with icons are still at top of worksheet. I can use the
>> >> > Alt =
>> >> > F,
>> >> > E
>> >> > etc to get some items to open but need the Menu items back. It is
>> >> > "checked"
>> >> > in the toolbars listing but it does nothing to "uncheck" it either.
>> >> > Suggestions please.
>> >> > --
>> >> > Mickey
>> >>
>> >>
>> >>
>>
>>
>>