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" wrote in message
...
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