ExcelBanter - A difficult question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - A difficult question (https://www.excelbanter.com/excel-programming/327640-difficult-question.html)

A difficult question

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

A difficult question

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

A difficult question

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

A difficult question

Not here you haven't!

--

HTH

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

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