Pull Down Menu Bar

My pull down menu bar has disappeared from my excel worksheets. Not sure
what I did to make this happen and cannot find anything in help except for
toolbars. Can some one please tell me how to get the pull downs turned back
on>

Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to get to the immediate window

type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true



JB in Kansas wrote:
>
> My pull down menu bar has disappeared from my excel worksheets. Not sure
> what I did to make this happen and cannot find anything in help except for
> toolbars. Can some one please tell me how to get the pull downs turned back
> on>

--

Dave Peterson

Dave,
Thanks a lot it worked. In fact I have put it in my "Personal" VBA's so I
will never have to ask again.

Once again thanks.

"Dave Peterson" wrote:

> Hit alt-f11 to get to the VBE (where macros live)
> hit ctrl-g to get to the immediate window
>
> type this and hit enter:
> application.CommandBars("worksheet menu bar").Enabled = true
>
>
>
> JB in Kansas wrote:
> >
> > My pull down menu bar has disappeared from my excel worksheets. Not sure
> > what I did to make this happen and cannot find anything in help except for
> > toolbars. Can some one please tell me how to get the pull downs turned back
> > on>
>
> --
>
> Dave Peterson
>