Not here you haven't!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"filo666" <filo666@discussions.microsoft.com> wrote in message
news:F7E7ACEE-4B05-48FD-86C6-D66EF98BEA50@microsoft.com...
> you know something: you are a genius¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
>
> I have been asking the same question for month and nobody could've answer
me
>
> Thaaaanksssssss
>
> "Tom Ogilvy" wrote:
>
> > Application.CommandBars("Worksheet Menu Bar").Enabled = False
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "filo666" <filo666@discussions.microsoft.com> wrote in message
> > news:01546D27-1BD2-47C0-A7D9-1070A8775C96@microsoft.com...
> > > Hi, I want to close all the tool boxes i an excel's workbook, but look
one
> > > line before the en sub line (Application.CommandBars("Worksheet Menu
> > > Bar").Visible = False)
> > > I can't close the menu bar, and I really need to close it, when I do
this
> > > manually it closes but when I live the custimize dialog box appears
> > again¡¡¡
> > > What should I do????
> > >
> > > I attach the macro:
> > >
> > >
> > > Sub Macro1()
> > > Application.CommandBars("Standard").Visible = False 'OK
> > > Application.CommandBars("Formatting").Visible = False 'OK
> > > Application.CommandBars("Stop Recording").Visible = False 'OK
> > > Application.CommandBars("Worksheet Menu Bar").Visible = False 'not
> > > woorking
> > > End Sub
> >
> >
> >