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