A difficult question

filo666 · 04-18-2005, 11:06 AM

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

Tom Ogilvy · 04-18-2005, 11:06 AM

Application.CommandBars("Worksheet Menu Bar").Enabled = False

--
Regards,
Tom Ogilvy

"filo666" <[email protected]> wrote in message
news:[email protected]...
> 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

filo666 · 04-18-2005, 12:06 PM

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

Bob Phillips · 04-18-2005, 01:06 PM

Not here you haven't!

--

HTH

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

"filo666" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >